in

SMSUG.ca

...your virtual communITy
All Tags » SQL (RSS)

Browse by Tags

  • Sample SQL query to show max RAM based on Model.

    This question was posted in the Usenet groups.. "I need to present a report that shows the maximum supported memory configuration for a system type, so I would like to be able to have a column on my report that shows the maximum supported memory, based upon the field , v_GS_Computer_system.model0 AS...
    Posted to Garth Jones (Weblog) by Garth on 01-15-2007
  • List all PCs without a DVD

    This SQL query will, list all PCs without a DVD SELECT Distinct v_GS_COMPUTER_SYSTEM.Name0 AS 'PC Name', v_GS_COMPUTER_SYSTEM.UserName0 AS 'User Name' FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM WHERE v_GS_COMPUTER_SYSTEM.ResourceID not in (SELECT Distinct v_GS_CDROM.ResourceID FROM v_GS_CDROM v_GS_CDROM...
    Posted to Garth Jones (Weblog) by Garth on 01-15-2007
  • How to find all the workstations within a two or more IP ranges.

    SELECT DISTINCT v_GS_COMPUTER_SYSTEM.Name0 AS 'PC Name', v_GS_COMPUTER_SYSTEM.UserName0 AS 'User Name', v_GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 as 'Gateway' FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM, v_GS_NETWORK_ADAPTER_CONFIGUR v_GS_NETWORK_ADAPTER_CONFIGUR WHERE v_GS_NETWORK_ADAPTER_CONFIGUR...
    Posted to Garth Jones (Weblog) by Garth on 01-12-2007
  • How to find all PCs with a Disk Array

    Use this query to find all PCs with a Disk Array SELECT distinct v_GS_COMPUTER_SYSTEM.Name0 as 'PC Name' , v_GS_COMPUTER_SYSTEM.UserName0 as 'User Name' FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM, v_GS_DISK v_GS_DISK WHERE v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_DISK.ResourceID AND ((v_GS_DISK.Description0...
    Posted to Garth Jones (Weblog) by Garth on 01-10-2007
  • Enterprise vs OEM

    Did you every want to know how many copies of MS Office you had that were Enterprise vs OEM? This SQL query along with your SMS data will help you out in finding this data. select DisplayName0 as 'Product', case right(left(Prodid0,3),1) When '0' then 'Enterprise' When '1' then 'Retail/OEM' when '2' then...
    Posted to Garth Jones (Weblog) by Garth on 01-08-2007
  • How to find out about User Groups within Canada!

    Have you ever wonder if there is a User group in your area? Why not find out! http://www.microsoft.com/canada/technet/community/usergroups/default.aspx If you do find a user group within your area, why not volunteer, most user group are always looking for people to help out. They are always looking for...
    Posted to Garth Jones (Weblog) by Garth on 01-07-2007
  • What hot fixes have been updated in the last month?

    Use this SQL query to find all Hot fixes update within ITMU in the last month. SELECT Distinct v_GS_PATCHSTATEEX.ID0 as ' ID', v_GS_PATCHSTATEEX.Product0 as 'Product', v_GS_PATCHSTATEEX.QNumbers0 as 'KB #', v_GS_PATCHSTATEEX.Title0 as 'Title' FROM v_GS_PATCHSTATEEX v_GS_PATCHSTATEEX WHERE datediff(MM...
    Posted to Garth Jones (Weblog) by Garth on 01-03-2007
  • Vista SQL Queries

    I have created a few SQL queries to help determine the cost of deploying Vista based on the current SMS inventory. Vista upgrade and deployment This SQL query will help you determine the cost of upgrading and deploying Vista, using the SMS database. Vista Planning Query This SQL query will help you determine...
    Posted to Garth Jones (Weblog) by Garth on 01-02-2007
Page 40 of 40 (398 items) « First ... < Previous 36 37 38 39 40
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems