...
23
Rack Mount Chassis (Physical Server)
24
Sealed-Case PC
SQL Query
You should run the following SQL query against the SMS/SCCM database to spit out an entire list of machines ...
There is no collection for Windows Server 2008 R2 systems in ConfigMgr 2007 by default that I can see, so I had to create one. It’s actually really easy to do if you just copy the query for an existing ...
There is no collection for Windows Server 2008 systems in ConfigMgr 2007 by default that I can see, so I had to create one. It’s actually really easy to do if you just copy the query for an existing OS ...
All Even Production Server Systems:
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client ...
... group is built each time an email is sent to it.
This is accomplished by utilizing a Lightweight Directory Access Protocol (LDAP) query that has been defined and assigned to the group. For example, you ...
... query the data store for configuration information. The data store provides a repository of persistent information. For this reason, you would want your data store to be in the same location as most of ...
... on New Query and either copy and paste the script into the Query window, or drag the sp_SFTcleanupusage_update.sql file to the window. Click on the check icon (Parse) to verify all is well, and then click ...