Endpoint Protection

Hi Team,

Could you please share SQL DB Query needed on 2hrs all computer status report to pull from SQL DB.

To pull what info? Any and all queries for computer status are found here:

https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database

To pull cmputer status report for 24hrs all repoted with query,

computer name,

version updated,

last time status change,

restart required,

IP address,

free disk space.

operating,

client version system

computer domain name

Some of what you are asking for is a little unclear to me but this query should get you going. You can also check out the EVT_Reboot table for some data regarding reboots that have occurred as events.

SELECT        dbo.vAllComputerInfo.Name AS Expr1, dbo.vAllComputerInfo.Status, dbo.Inv_AeX_AC_TCPIP.[IP Address], dbo.vAllComputerInfo.[OS Name],
                         dbo.vAllComputerInfo.[OS Version], dbo.Inv_AeX_AC_Identification.Domain, dbo.Inv_HW_Logical_Disk.[File System], dbo.Inv_HW_Logical_Disk.[Free Space (Bytes)],
                         dbo.Inv_HW_Logical_Disk.Name, dbo.Inv_HW_Logical_Disk.[Size (Bytes)]
FROM            dbo.vAllComputerInfo LEFT OUTER JOIN
                         dbo.Inv_HW_Logical_Disk ON dbo.vAllComputerInfo.Guid = dbo.Inv_HW_Logical_Disk._ResourceGuid LEFT OUTER JOIN
                         dbo.Inv_AeX_AC_Identification ON dbo.vAllComputerInfo.Guid = dbo.Inv_AeX_AC_Identification._ResourceGuid LEFT OUTER JOIN
                         dbo.Inv_AeX_AC_TCPIP ON dbo.vAllComputerInfo.Guid = dbo.Inv_AeX_AC_TCPIP._ResourceGuid

Hope this helps you out.