Browse by Tags

Query SMS 2.0 And SMS 2003 Sites Current Service Pack Level

Use the SQL script below to find your SMS sites service pack version level for SMS 2.0 or SMS 2003 sites. SQL Query: Select SiteCode , SiteServer , SiteName , 'Version' = Case When Version between '2.00.1239.0000' And '2.00.1239.0999' Then 'SMS Version 2.0 RTM' When Version between '2.00.1380.1000' And...

Posted to Don Hite (Weblog) by dhite on 04-08-2007
Filed under: SQL Queries, SMS 2003
Linking SMS And MOM Server Databases For Distributed Queries

This post will show you how to retrieve data that resides on a remote MOM database server from an SMS database server for writing distributed queries. SMS and MOM both capture and record into their respective SQL databases a great deal of information about networked resources among other things. You...

Posted to Don Hite (Weblog) by dhite on 03-15-2007
Filed under: SQL Queries, SMS 2003, Microsoft SQL Server, MOM 2005
Inactive And Obsolete Machines Query

Active This data type is initially set to 1 (Yes) and is set to 0 (No) when the client health tools determines that the client failed its checks and finds that the client is either not in a healthy state or is no longer on the network. Obsolete This data type is initially set to 0 (No) and is set to...

Posted to Don Hite (Weblog) by dhite on 08-19-2006
Filed under: SQL Queries, SMS 2003
Query Machines Ready For ITMU Installation

ITMU requires that your client machines have Windows installer Version 3.1 installed and the Automatic Updates must be running. Use the Query below to find those machines that are ready for ITMU. SQL Query: Select System . Netbios_Name0 'Machine Name' , System . User_Name0 'User Name' , Services . DisplayName0...

Posted to Don Hite (Weblog) by dhite on 07-16-2006
Filed under: SQL Queries, SMS 2003
Determining What Site Server Is Defined As Your Server Locator Point

Introduced in SMS 2003 the SMS Server Locator Point role was created to function much like an index in a book. You turn to the index in a book or manual to find a specific entry in the book. The same basic function is used here. Server Locator Point (SLP) servers help your legacy clients find their Client...

Posted to Don Hite (Weblog) by dhite on 06-18-2006
Filed under: SQL Queries, SMS 2003
All Systems Inventory Query

When you use the SMS administrators console to view your “All Systems” Resource collection (CollectionID: SMS00001) you are presented with an overview of all the resources that SMS has discovered. However if you are like me you avoid the console if at all possible. It is not that I dislike the console...

Posted to Don Hite (Weblog) by dhite on 06-11-2006
Filed under: SQL Queries, SMS 2003
Find Machines Installed And Assigned To Different Sites

When you are upgrading an existing SMS 2.0 installation to SMS 2003 you may find that there are machines that are installed and assigned to different sites. To a lesser degree you may find that some of your older clients may be installed or assigned to an old site database. In order to monitor your upgrade...

Posted to Don Hite (Weblog) by dhite on 05-28-2006
Filed under: SQL Queries, SMS 2003
Reviewing Machines Last Hardware And Software Update Times

There have been many queries posted over the years that allow you to find machines in your SMS database that have not reported hardware or software inventory data in a timely manner. Here you will find a slight twist on the queries that have been published or posted in the past by myself and others....

Posted to Don Hite (Weblog) by dhite on 05-21-2006
Filed under: SQL Queries, SMS 2003
Deleting Machines Directly From The SMS Database

To delete an individual machine from the SMS database using the SMS console it is necessary to create a collection using the direct membership rule wizard or base your new collection on a newly created Query. The first method is slow and can be time consuming, the second option just doubles your work...

Posted to Don Hite (Weblog) by dhite on 05-14-2006
Filed under: SQL Queries, SMS 2003
Quick SMS Component Status Check

For those people that have only one SMS primary site server to manage opening the SMS administrations console and looking at the System Status leaf is usually not much of a time consuming chore. However if you have a parent site with several sites below it that task can start to become a taxing operation...

Posted to Don Hite (Weblog) by dhite on 04-10-2006
Filed under: SQL Queries, SMS 2003, Microsoft SQL Server

Page 1 of 1 (10 items)