sathwet@gmail.com
- Sath Wetthasingha PGD(UK),Dip-BCS(UK),Dip-NCC(UK),MCSE,MCT,MCLC,MACS,MBCS,MCTS,ACIW
- Melbourne, VIC, Australia
- I’m specialized in Microsoft technologies and information security. I always willing to ride an extra mile to help the IT community sharing my past experience and technical knoladge.
Wednesday, September 7, 2011
Computers not reported in 30 days in SCCM
select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where SMS_R_System.Name in (select Name from SMS_R_System where ((DATEDIFF(day, SMS_R_SYSTEM.AgentTime, getdate()) >=30) and AgentName = "SMS_AD_SYSTEM_DISCOVERY_AGENT")) and SMS_R_System.Name in (select Name from SMS_R_System where ((DATEDIFF(day, SMS_R_SYSTEM.AgentTime, getdate()) >=30) and AgentName = "Heartbeat Discovery"))
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment