Solved

Find last active date of SMS client?

Posted on 2009-04-08
2
835 Views
Last Modified: 2013-11-21
What is the easiest way to see the last time a SMS client was active?  I have several machines that show up in the database that no longer exist.  For now, this is how we actually want it.  But I need to run a query and see what is really out there.  I tried to run a Last Hardware Scan query but this isnt the filter Im looking for.  Just need to show the last check-in time I guess you could call it.

Thanks!
0
Comment
Question by:NBquery
2 Comments
 
LVL 6

Accepted Solution

by:
question earned 250 total points
ID: 24119595
See below SQL queries
SELECT SMS_R_System.Name0 AS [Computer Name], v_RA_System_IPAddresses.IP_Addresses0 AS [IP Address],
SMS_R_System.Active0 AS [Is SMS Client Active?], SMS_R_System.Obsolete0 AS [Is SMS Client Obsolete ?],
SMS_G_System_LastSoftwareScan.LastUpdateDate AS [Last Software Inventory],
___System_WORKSTATION_STATUS0.LastHWScan AS [Last Hardware Inventory], SMS_R_System.SMS_Unique_Identifier0 AS [SMS GUID], SMS_G_System_OPERATING_SYSTEM.Caption0 AS [Operating System]
FROM System_DISC SMS_R_System INNER JOIN
Operating_System_DATA SMS_G_System_OPERATING_SYSTEM ON
SMS_G_System_OPERATING_SYSTEM.MachineID = SMS_R_System.ItemKey INNER JOIN
SoftwareInventoryStatus SMS_G_System_LastSoftwareScan ON SMS_G_System_LastSoftwareScan.ClientId = SMS_R_System.ItemKey INNER JOIN
WorkstationStatus_DATA ___System_WORKSTATION_STATUS0 ON ___System_WORKSTATION_STATUS0.MachineID = SMS_R_System.ItemKey INNER JOIN
v_RA_System_IPAddresses ON SMS_R_System.ItemKey = v_RA_System_IPAddresses.ResourceID
WHERE (SMS_R_System.Active0 = 0)
ORDER BY SMS_R_System.Name0

Obsolete SMS Clients

SELECT SMS_R_System.Name0 AS [Computer Name], v_RA_System_IPAddresses.IP_Addresses0 AS [IP Address],
SMS_R_System.Active0 AS [Is SMS Client Active?], SMS_R_System.Obsolete0 AS [Is SMS Client Obsolete ?],
SMS_G_System_LastSoftwareScan.LastUpdateDate AS [Last Software Inventory],
___System_WORKSTATION_STATUS0.LastHWScan AS [Last Hardware Inventory], SMS_R_System.SMS_Unique_Identifier0 AS [SMS GUID],
SMS_G_System_OPERATING_SYSTEM.Caption0 AS [Operating System]
FROM System_DISC SMS_R_System INNER JOIN
Operating_System_DATA SMS_G_System_OPERATING_SYSTEM ON
SMS_G_System_OPERATING_SYSTEM.MachineID = SMS_R_System.ItemKey INNER JOIN
SoftwareInventoryStatus SMS_G_System_LastSoftwareScan ON SMS_G_System_LastSoftwareScan.ClientId = SMS_R_System.ItemKey INNER JOIN
WorkstationStatus_DATA ___System_WORKSTATION_STATUS0 ON
___System_WORKSTATION_STATUS0.MachineID = SMS_R_System.ItemKey INNER JOIN
v_RA_System_IPAddresses ON SMS_R_System.ItemKey = v_RA_System_IPAddresses.ResourceID
WHERE (SMS_R_System.Obsolete0 = 1)
ORDER BY SMS_R_System.Name0
0
 

Author Closing Comment

by:NBquery
ID: 31568343
Did not get a chance to test out.
0

Featured Post

Promote certifications in your email signature

Has your company recently won an award or achieved a certification? They'll no doubt want to show it off. Email signature images used to promote certifications & awards can instantly establish credibility with a recipient and provide you with numerous benefits.

Join & Write a Comment

Consider a situation when you deploy a seemingly harmless software package to your network without testing and therefore without fully knowing the implications of your actions. I was recently involved in just this situation when a corporate IT netwo…
Every system administrator encounters once in while in a problem where the solution seems to be a needle in haystack.  My needle was an anti-virus version causing problems with my Exchange server. I have an HP DL350 with Windows Server 2008 Stand…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now