in reply to
Re: Extracting WQL "count" results
in thread Extracting WQL "count" results
I'm guessing the SMS in 'SMS database' refers to Microsoft's Systems Management Server. While based on SQL Server, it appears that accessing the underlying tables without going through the 'official channels is somewhat frowned upon:
You should never attempt to obtain SMS data by directly accessing the SQL Server tables on the SMS site database system. Always access SMS data through the SMS Provider, using the appropriate WMI libraries distributed with the WBEM SDK or on the SMS 2.0 CD.