in

SMSUG.ca

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

Browse by Tags

  • Query to report OU information for Machines

    For full details please see: http://www.myitforum.com/forums/query-to-report-OU-information-for-Machines-m235317.aspx   select R.Name0, max (OU.System_OU_Name0) From dbo.v_R_System R join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = R.ResourceID join dbo.v_FullCollectionMembership FCM on FCM...
    Posted to Garth Jones (Weblog) by Garth on 04-05-2012
  • Last Reboot Report

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/e0147d8a-8946-42bb-b6ed-a3c92bae5b23   select distinct R.ResourceID, R.Netbios_Name0 AS ' Computer Name ', OS.LastBootUpTime0 AS ' Last Boot Time ', R.Resource_Domain_OR_Workgr0 AS '...
    Posted to Garth Jones (Weblog) by Garth on 03-18-2012
  • Lists people and how much they've been using specified software with OU fix

    For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=234978&mpage=1#234980 select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', ou.ou as OU, round( sum (MUS.UsageTime)/60.0,2) as ' Forbrug (min) ' from dbo...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2012
  • Lists people and how much they've been using specified software

    For full details see: http://www.myitforum.com/forums/Need-some-SQL-help-think-its-simple-m234978.aspx select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', replace( max (ou.User_OU_Name0),' Gartek.LOCAL/Ottawa/ ',' ') as OU...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2012
  • 78!

    I have been told that we are 78 people short of the 1200 people for tomorrows Webcast! Will you be the one to help set a new record for myITForm webcast? Sign up now! http://bit.ly/yMimvp   And don’t forget that I have BIG news to spill at the end of the Webcast!
    Posted to Garth Jones (Weblog) by Garth on 03-13-2012
  • Report for matching names

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/8bda0fe9-7d80-44d0-9a52-f1f573423abf/   select CS.ResourceID, cs.NAME0, PC2.name0, substring (CS.NAME0,5,LEN(cs.NAME0)) from dbo.v_GS_COMPUTER_SYSTEM CS, ( select CS.ResourceID, cs.NAME0, substring ...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
  • Link v_MeteredUser.FullName to a full name from ad

    To see the full post http://www.myitforum.com/forums/How-to-link-v_MeteredUserFullName-to-a-full-name-from-ad-m234899.aspx select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
  • BIG NEWS!!!!

    I have big news but there is a catch….. I can’t say much until Wednesday at noon PST! J Which works out perfectly, as that is almost the exact time that I will be finishing my SCCM Guru webcast! So make sure that your register for the session to hear it Live! http://bit.ly/yMimvp   oh, you want...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • Link to Name

    For full details see post here. http://www.myitforum.com/forums/tm.aspx?high=&m=234875&mpage=1#234894   select ARP.resourceid, CS.Name0, max (ARP.version0) as JavaVersion from dbo.v_GS_COMPUTER_SYSTEM as CS join dbo.v_ADD_REMOVE_PROGRAMS as ARP on CS.ResourceID = ARP.ResourceID where ARP...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • Cannot get rid of duplicate rows on an Add or Remove Programs query

    For for details see post. http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/3bea8fa6-968a-4f0e-b412-469577e409aa Select DISTINCT SYS.Netbios_Name0 AS ' Name ', case SEM.ResourceID When NULL THEN ' N ' Else ' Y ' End AS ' SafeNet? ', ARP. Timestamp...
    Posted to Garth Jones (Weblog) by Garth on 03-04-2012
Page 5 of 40 (398 items) « First ... < Previous 3 4 5 6 7 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems