Solved

Find last active date of SMS client?

Posted on 2009-04-08
2
843 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 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