in

SMSUG.ca

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

Browse by Tags

  • Don’t you love emails like this one!

    I left ITProTeach (DevTeach) a bit early so that I could head home to pack before my long overdue vacation! After getting back, I found this nice surprise in my inbox!   If you want to download the PPT, you can find it in Enhansoft’s blog http://support.enhansoft.com/Blogs/post/Diving-Deep-in-the...
    Posted to Garth Jones (Weblog) by Garth on 11-14-2011
  • Simple History query

    Select distinct SD.Name0 'Machine Name' , HARP.DisplayName0 as '32bit' , HARP.Version0, HARP64.DisplayName0 as '64bit' , HARP64.Version0, SD.User_Name0 'User Name' From v_R_System SD Join v_FullCollectionMembership FCM on SD.ResourceID = FCM.ResourceID Join v_Collection...
    Posted to Garth Jones (Weblog) by Garth on 10-22-2011
  • Advertisements, Programs and Main User of all PC

    SELECT A . AdvertisementName , A . ProgramName , R . Netbios_Name0 as Computername , SCUM . TopConsoleUser0 as MainUsername FROM dbo . v_R_System_Valid R join dbo . v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on R . ResourceID = SCUM . ResourceID join dbo . v_ClientAdvertisementStatus CAS on R . ResourceID...
    Posted to Garth Jones (Weblog) by Garth on 10-01-2011
  • Serial Number, User Information and installation dates of the software

    SELECT adv . AdvertisementName , stat . LastStateName , adv . Comment AS C072 , pkg . Name AS C062 , adv . ProgramName AS C071 , adv . SourceSite , adv . AdvertisementID , se . SerialNumber0 , cs . UserName0 , Stat . LastAcceptanceStatusTime FROM v_Advertisement adv JOIN v_Package pkg ON adv . PackageID...
    Posted to Garth Jones (Weblog) by Garth on 09-28-2011
  • PC Var data

    select Name , Value , Masked from MEP_MachineVariables where MachineID = 63
    Posted to Garth Jones (Weblog) by Garth on 08-28-2011
  • RAM by User name

    SELECT Distinct SYS.Netbios_Name0 , SYS.Operating_System_Name_and0 , MEM . TotalPhysicalMemory0 / 1024 As C083 FROM v_R_System SYS JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM . ResourceID WHERE User_Name0 = 'Garth'
    Posted to Garth Jones (Weblog) by Garth on 08-06-2011
  • Harddisk changes

    Select CS . Name0 , HD . DeviceID0 , HD . Index0 , HD . Size0 , HHD . Size0 from dbo . v_GS_COMPUTER_SYSTEM CS join dbo . v_GS_DISK HD on CS . ResourceID = HD . ResourceID join dbo . v_HS_DISK HHD on CS . ResourceID = HHD . ResourceID Where HD . Size0 <> HHD . Size0 And HD . DeviceID0 = HHD . DeviceID0...
    Posted to Garth Jones (Weblog) by Garth on 07-29-2011
  • Report for listing all the devices a users has logged onto along with their last logon time

    SELECT DISTINCT Max ( HCU . LastConsoleUse0 ), HCU . SystemConsoleUser0 , S . Name0 FROM dbo . v_GS_SYSTEM S join dbo . v_HS_SYSTEM_CONSOLE_USER HCU on S . ResourceID = HCU . ResourceID WHERE HCU . SystemConsoleUser0 = 'Enhansoft\Garth' group by S . Name0 , HCU . SystemConsoleUser0 Order by S...
    Posted to Garth Jones (Weblog) by Garth on 07-27-2011
  • Report for software update article ID

    SELECT DISTINCT UI . BulletinID as 'BulletinID' , UI . ArticleID as 'ArticleID' , UI . Title as 'Title' , 'Deployed' = ( case when CTM . ResourceID is not null then 'Yes' else 'No' end ), UI . InfoURL as 'URL' , UI . CI_UniqueID as 'Unique ID'...
    Posted to Garth Jones (Weblog) by Garth on 07-25-2011
  • Query for Drivers within the Boot Image

    SELECT bip . PkgID as 'Boot Package' , SMS_Driver . DisplayName as 'Driver Name' , SMS_Driver . LocaleID as 'Local' , bip . SourcePath as 'SourcePath' , drv . DriverINFFile as 'INF' FROM BootImgPkg_References as bip INNER JOIN CI_ConfigurationItems as cc ON cc...
    Posted to Garth Jones (Weblog) by Garth on 07-25-2011
Page 4 of 7 (63 items) « First ... < Previous 2 3 4 5 6 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems