Software last run more the X days ago
----------------
select distinct SMS_R_System.ResourceId, SMS_R_System.Name from SMS_R_System inner join SMS_G_System_SoftwareUsageData on SMS_G_System_SoftwareUsageData.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareUsageData.FileName = "sol.exe" and SMS_G_System_SoftwareUsageData.StartTimeLocal > DateAdd(dd,-6,GetDate())
Software NOT run in x days
-----------------
select distinct SMS_R_System.ResourceId, SMS_R_System.Name from SMS_R_System where SMS_R_System.ResourceId not in (select distinct SMS_R_System.ResourceId from SMS_R_System inner join SMS_G_System_SoftwareUsageData on SMS_G_System_SoftwareUsageData.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareUsageData.FileName = "sol.exe" and SMS_G_System_SoftwareUsageData.StartTimeLocal > DateAdd(dd,-6,GetDate()))
Monday, February 8, 2010
Tuesday, February 2, 2010
Win 7 clients for SMS 2003
Microsoft has added support for Win7 and Server 2008 R2 clients in SMS 2003 SP3.
More information can be found here
http://support.microsoft.com/?kbid=974014
This should be used as a stepping stone as people move from SMS 2003 to SCCM 2007 or even V.Next due out sometime next year. Since main stream support has ended I would recommend people look at moving not just because support has ended but because the added benifits that are in 2007 Sp2 R2.
If you intend on staying with 2003 and jump 2007 then I would recommend that you download the ConfigMgr 2007 R2 VHD http://www.microsoft.com/downloads/details.aspx?FamilyID=e0fadab7-0620-481d-a8b6-070001727c56&displaylang=en
to play with and see how it all works so you will be better prepaired for the next version.
More information can be found here
http://support.microsoft.com/?kbid=974014
This should be used as a stepping stone as people move from SMS 2003 to SCCM 2007 or even V.Next due out sometime next year. Since main stream support has ended I would recommend people look at moving not just because support has ended but because the added benifits that are in 2007 Sp2 R2.
If you intend on staying with 2003 and jump 2007 then I would recommend that you download the ConfigMgr 2007 R2 VHD http://www.microsoft.com/downloads/details.aspx?FamilyID=e0fadab7-0620-481d-a8b6-070001727c56&displaylang=en
to play with and see how it all works so you will be better prepaired for the next version.
Monday, February 1, 2010
MMS 2010 Sesions list has been posted
For those looking at attenting MMS 2010 the sessions have now been posted. This list might change as more speakers accept or decline the offer. Expect to see dates/times by mid Feburary. You may use the drop down menu or simply download the latest PDF file to see all the sessions.
http://www.mms-2010.com/public/sessions.aspx
http://www.mms-2010.com/public/sessions.aspx
Subscribe to:
Posts (Atom)