Recent Posts Tagged With 'sql queries'

• SQL Query To Find Software Product Information For Machines In A Specified Collection

  Posted on Sunday September 21st, 2008 at 15:03 in sql queries

    This is actually a By Request SQL query to list software product information including the machine name, company name, and product name and product versions for machines in a specified collection.    This query uses the All Systems ...

• SQL Query To Retrieve The Column Names From A Specified Table Name

  Posted on Sunday September 14th, 2008 at 15:53 in sql queries

    This SQL Query will allow you to view the column names for a specified SQL table name sorted by their Ordinal position.   SQL Query:   Select Column_Name From Information_Schema.Columns   Where Table_Name = 'System_Disc'...

• SQL Query To Retrieve Table Column Names Where Null Values Are Allowed

  Posted on Sunday September 14th, 2008 at 15:53 in sql queries

    This SQL Query will allow you to view the column names for all of the tables in a specified database where Null values are set to True sorted by their Ordinal position.   SQL Query:   Select Table_Name, Column_Name   From Inform...

• SQL Query To Find Machines With Office 2007 Applications Using Multiple Like Statements

  Posted on Sunday September 14th, 2008 at 15:52 in sql queries

    This SQL Query will allow you to find machines that have Microsoft Office 2007 applications installed as registered in the Add and Remove Applications applet using multiple LIKE statements.   SQL Query:   Select SD.Name0, AP.Displa...

• SQL Query To List Advertisements For A Specified Collection

  Posted on Sunday September 7th, 2008 at 12:25 in sql queries

    This SQL Query will list all of the Advertisements and their corresponding Advertisement ID’s for a specified collection name such as ‘All Client Systems’.   SQL Query:   Select A.AdvertisementName, A.Advertisemen...

• SQL Query To Filter Out Clients With Invalid System Enclosure Asset Tag Information

  Posted on Sunday September 7th, 2008 at 12:24 in sql queries

    This SQL Query will filter out all of the invalid system enclosure asset tags using NOT NULL, Not Like (<>) and NOT IN SQL commands.   SQL Query:   Select SD.Name0 'Machine Name', SD.User_Name0 'User Name', S...

• SQL Query To List Add And Remove Programs For A Specified Machine Excluding Updates And Hot Fixes

  Posted on Sunday August 24th, 2008 at 13:06 in sql queries

    This SQL Query will allow you to list the installed applications registered in the Add and Remove Applications applet for a specified machine excluding those applications such as Security Updates and Hot fixes and other system updates.   ...