Report of clients that do not have endpoint installed yet (AD Integrated)
Updated: 21 May 2010 | 6 comments
This issue has been solved. See solution.
I'm wondering if anyone has found a way to report on clients that do not have Endpoint installed yet? I've integrated AD with Endpoint and it seems to me that I should fairly easily be able to run a report that tells me what clients do not yet have Endpoint installed. If that is not possible, has anyone figured out what tables in the SQL database I could pull a report from to get this type of info? I've looked into turning on the unmanaged detectors, but we have WAY to many IP enabled devices to go about excluding all of those from our reports.
discussion Filed Under:
Comments
The only reports I have
The only reports I have managed to get so far are for those clients that have SEP installed on them. So You could just extract those and compare it with a list from the AD.
I'm sure SEP would bypass non PC network devices. We have deployed SEP to 12k++ clients and this company have network devices and IP phones on a class A network (with subnetting, of course)
“Your most unhappy customers are your greatest source of learning.”
We run SQL reporting services
We run SQL reporting services as additional reporting for SEP.
I used the tables SEM_CLIENT and SEM_COMPUTER from the SEP database.
All AD imported information is stored in SEM_CLIENT and all clients that have SEP installed AND have checked in with the SEPM are stored in table SEM_COMPUTER.
Hope this helps.
Thanks Erik, I'll dig into
Thanks Erik, I'll dig into this (sorry for the delay, was off in la-la land working on other issues).
Yep, thats the report we
Yep, thats the report we wanted, just wish this were built into the product, since the information is there already....
I am wondering if this can be
I am wondering if this can be applied to the internal sybase database. That's good to know.
Mike
I would think if you can run
I would think if you can run a query against it you should be able to...I'm not at all familiar with sybase however so I'd have to leave that to someone who is.
Would you like to reply?
Login or Register to post your comment.