can anyone tell me where the custom machine variable is stored in the sms database? if i right click on a machine, properties, variables, and create a custom variable, i need to know where it is stored in the Database preferably in a view. Thanks in advance!!

What are you trying to accomplish? Are you quering the database for a report? http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

Machine Variables are stored in SQL. You can get these using a powershell script, or a SQL View... objComputer = gwmi -computername “$smsProvider” -namespace “root\sms\site_$siteCode” -class “sms_r_system” | where{$_.Name -eq $computerName} Just for your information: your example contains a WQL query (not a SQL one) and SMS_R_System is a WMI class, not a SQL view.Torsten Meringer | http://www.mssccmfaq.de

Yes, i'm looking for this for reporing purposes.

The above wmi query didn't return what i'm looking for. and i really need it from an sql table or view.