Find the column name of the given SMS table or view

select column_name,table_name from information_schema.columns
where table_name like '%' and column_name like '%serialnumber%' order by column_name

Description:

Many times , your client might have requested you to generate some adhoc reports from SMS Server. Sometimes we may not have information about the tables\views that contains the requested data. For example, if you do not know where is the information stored about serial number of SMS client machines, you can have a quick check by running above query. It lists out all the tables\views which contains the specified column name and easily you can reach out what you need!