V_ch_clientsummary has a LastMPServerName.

select *
from v_ch_clientsummary


Daniel Ratliff

From: [email protected] [mailto:[email protected]] On 
Behalf Of Nick Scott
Sent: Tuesday, August 25, 2015 11:57 AM
To: [email protected]
Subject: [mssms] Management Point report

I'm trying to create a report for ConfigMgr 2012 that will show the management 
point for each client. I've tried to find the SQL view that contains this 
information but I've come up empty so far. Does anyone know where this 
information is stored?

I have multiple management points and I'm looking to report on which clients 
are assigned to them.

Nick


The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material.  If you receive this 
material/information in error,
please contact the sender and delete or destroy the material/information.

Reply via email to