Symantec Management Platform (Notification Server)

Hello All,
Does anyone out there know if there is an Altiris report that will tell me when the laptops in my environment are undocked? The goal is to see if my users are actually taking there laptops off-site regularly, or if they stay docked most of the time. Any help is appreciated, thank you!!

This is a rough question. In short there is no report that can do what you are asking because different models of docking station show up as different things. You would have to write the report yourself.

This is where it gets difficult. Some docking stations have entries and appear in the device manager. Those you can run a report on through Altiris. Some odd models however do not see the docking stations at all as an extra device in the device manager. There is no real way to find those because the docking station doesn't report itself as a hardware device.

I spoke to Altiris support and they said I would need to write a custom SQL query to get this. I don't have any SQL knowledge, so if anyone out there knows how to write a SQL query that will show me the inactive computers, I would really appreciate it! In Deployment Server, there is a filter called "Inactive Computers" that shows me exactly what I need to know. Unfortunately, Altiris tells me that the Deployment Server database and the Notification Server database are two separate databases, and Notification Server won't show me what Deployment Server will, so they say I need to write a custom SQL query that will pull that from the Deployment Server database, but I have no idea how to do that. Any help is greatly appreciated!!

SELECT dbo.computer.name, dbo.inactive_computers.disconnect_time
FROM dbo.computer INNER JOIN dbo.inactive_computers ON dbo.computer.computer_id = dbo.inactive_computers.computer_id;