Endpoint Protection

Hello,

We have thousdands of PC's that we would like to ensure are communicating with SEPM, is there a script way of searching for the host name already out there, such as move vbs script, where once can give a list of host name and the result is whether or not they are in SEPM?

I wish but there is nothing that I know of for this. A powershell module would be nice but SEPM does not support powershell.

You could export the computer status report to CSV and do a vlookup in excel against your list of machines.

When creating the report, you can configure it to show only online machines.

You can export computer status report.

what if one has access to the actual server where SQL database is at, Since it is a Windows server with SQL on it, we should be able to query the database with a powershell script?

looking at this:

http://technet.microsoft.com/en-us/magazine/hh855069.aspx

maybe I will play around with this idea in the test lab, meanwhile, I welcome other suggestions.

You could run an SQL query to get that info. Computer status report is the quickest way and no risk of breaking anything since you won't be touching the backend DB.

right but the idea is to expand the initial script to parse through the data and only return the matches. Similar with what we can achieve in excel, but we need to do this often, so I prefer the scripting method. 

makes sense