Browse by Tags
October 01, 2008
Once upon a time to do a WMI query you had to use one of the following: WMIC Cumbersome Must be an administrator WBEMTEST Make the popup windows stop CIM Studio Why doesn’t this save my query? http://www.microsoft.com/downloads/details.aspx?familyid=6430F853-1120-48DB-8CC5-F2ABDC3ED314&displaylang=en Now we have PowerShell. PowerShell allows a lot of formatting, but check out how easy it is to query WMI: Note : Crtl+C breaks a query in PowerShell 1) Create the Query Object $q = New-Object System...
... Read
the full post or
be the first to comment.
Filed under: PowerShell, SMS 2003, SCCM, ConfigMgr, WMI
September 30, 2008
The easiest way is to change the SMS_ to V_ and look around in the SQL Database. Lots of great articles about that on myitforum. How about a query to match on partial table names: Select correct database. Usually SMS_<SiteCode> SELECT * FROM sysobjects WHERE name LIKE '%Compliance%' and xtype in ( 'U' , 'V' ) What is xtype? C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L = Log P = Stored procedure PK = PRIMARY KEY constraint (type...
... Read
the full post or
be the first to comment.
Filed under: SMS 2003, SCCM, WMI
June 06, 2008
Here is the situation. You need to find the SMS 2003 or ConfigMgr NameSpace in WMI and you don’t have the PowerShell expertise, yet. Easiest way is to use a GUI interface. Namely CIM Studio. CIM = Common Information Model… or framework of how info is stored in WMI. About CIM Studio http://technet.microsoft.com/en-us/library/cc181062.aspx Download CIM Studio http://technet.microsoft.com/en-us/library/cc181062.aspx Note : I would recommend book marking CIM studio in IE. Saves time finding it later...
... Read
the full post or
be the first to comment.
Filed under: SMS 2003, SCCM, ConfigMgr, WMI, CIM Studio