Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. colt1911carry

    Find all Pre-SP2 XP systems in organization

    I figures that part out. select SMS_G_System_COMPUTER_SYSTEM.Name, SMS_G_System_OPERATING_SYSTEM.CSDVersion, SMS_G_System_OPERATING_SYSTEM.Caption from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join...
  2. colt1911carry

    Find all Pre-SP2 XP systems in organization

    It seems to have run the query anyway (with the syntax error) but I get a list that includes several of my Windows 2003 Servers. Is there a way to filter those out?
  3. colt1911carry

    Find all Pre-SP2 XP systems in organization

    I got a syntax error on trying to run this.
  4. colt1911carry

    Find all Pre-SP2 XP systems in organization

    How do I do a query based collection?
  5. colt1911carry

    Find all Pre-SP2 XP systems in organization

    SP2 for XP
  6. colt1911carry

    Find all Pre-SP2 XP systems in organization

    I need to find a way to find all of my pre-sp2 XP machines so I can then do an upgrade to these. I am pretty new to SMS (we installed it mainly as a remote tools item, but now are looking to maximize it functionality). Any help is greatly appreciated.

Part and Inventory Search

Back
Top