SELECT v_Advertisement.AdvertisementName, v_Advertisement.ProgramName,Netbios_Name0 as Computername,v_GS_SYSTEM_CONSOLE_USER.SystemConsoleUser0 as MainUsername
FROM
(SELECT ResourceID, MAX(TotalUserConsoleMinutes0) as Anmeldezeit
FROM v_GS_SYSTEM_CONSOLE_USER
GROUP BY ResourceID) AS Table1,v_GS_SYSTEM_CONSOLE_USER, v_R_System_Valid, v_ClientAdvertisementStatus, v_Advertisement WHERE Table1.ResourceID = v_GS_SYSTEM_CONSOLE_USER.ResourceID
AND Table1.Anmeldezeit = v_GS_SYSTEM_CONSOLE_USER.TotalUserConsoleMinutes0
AND Table1.ResourceID = v_R_System_Valid.ResourceID
AND Table1.ResourceID = v_ClientAdvertisementStatus.ResourceID
AND v_ClientAdvertisementStatus.AdvertisementID = v_Advertisement.AdvertisementID
3/06/2009
SQL SCCM Query to return Advertisements, Programs and Main Users of all Computers
This SCCM SQL Query return each Computer, it's Advertisements & Programs and the Main User
Subscribe to:
Post Comments (Atom)
4 comments:
Sorry to post an unrelated comment here but I noticed form experts exchange that you managed to update your Cisco 1200 Access point from VXWorks to IOS.
I would like to do this but am unable to get hold of a verion of IOS to perform this.
I would like my Access point to support WPA encryption, please can you help me get this old equipment working?
Many thanks
I will check here for your comments,
Sorry for the late answer but my mail notification does not seem to work!
You need the tool Aironet-AP-Cisco-IOS-Conversion-Tool to perform the upgrade. Check out this for futher information: http://www.cisco.com/en/US/docs/wireless/access_point/conversion/ios/faq/CACT_FAQ.html
It is the best time to make some plans for the future and it's time to be happy. I have read this post and if I could I desire to suggest you some interesting things or advice. Maybe you can write next articles referring to this article. I wish to read more things about it!
Good day! I could have sworn I've been to this blog before but after checking through some of the post I realized it's new to me. Nonetheless, I'm definitely delighted I found it and I'll be bookmarking and checking back often!
Post a Comment