Reports from Management Center

---

rex wrote:

I was just wondering if there was a way to run a report off of the Management Center of all the users in group created in MC?  Or am I just better off with the good ol' screenshot?  TIA

-Rex

---

Hi rex,

If they are in the same OU or sub-OU it's possible. In Users & Computer, simply click on the Inventory tab to the right of that container. Running an Inventory report by group sounds like an interesting feature request.

A better way to pull reports is to do it directy via SQL.  There is a Knowledge center article on the support website with sample queries.  One query I use is cut/pasted below. This one pulls all users but could easily be modified to be group specific.

--
-- Query name: RPT DE User Machine Associations
--
-- This query lists all machines with Device Encryption installed along with the primary owner of each machine.
-- If a machine has no primary owner, all associated users are listed.
--
-- Machines with un-encrypted C drives will appear at the top of the report.
--
-- Owner: 0 = User is not owner (Box is not checked), 1 = User is owner (box is checked)
--        null = User is not owner (Box is not checked and grey)
--
-- Deny Ownership: 0 = User can become owner (Green Check), 1 = User cannot become owner (Red X)
--                 null = User cannot become owner (Yellow Question Mark)
--
-- Type: 0 = "Copy User", 2 = "Central"
--

USE safeguard

SELECT A.iif_feature as 'Module'
, A.iif_feature_version as 'Version'
, B.sgd_name as 'Machine'
, C.ima_encrypted_drives as 'Drive Encrypted'
, C.ima_unencrypted_drives as 'Drive Not Encrypted'
, C.ima_last_policy_received as 'Last Policy Received'
, D.uma_is_owner as 'Owner'
, E.usr_logon_name as 'UserID'
, E.usr_first_name as 'First Name'
, E.usr_initials as 'MI'
, E.usr_last_name as 'Last Name'
, E.usr_email as 'Email'
, D.uma_type as 'Type'
, D.uma_deny_ownership as 'Can Become Owner'
--, CASE WHEN D.uma_type = '0' THEN 'Copy User' ELSE 'Central' END as 'Type'
--, CASE WHEN D.uma_deny_ownership = '0' THEN 'Yes' ELSE 'No' END as 'Can Become Owner'
--, E.usr_logon_domain as 'User Domain'
, B.sgd_dsn as 'Machine Distinquished Name'

FROM ivt_inst_features A
LEFT JOIN safe_guard_dir B ON B.sgd_id = A.iif_machine_id
LEFT JOIN ivt_machines  C ON C.ima_machine_id = A.iif_machine_id
LEFT JOIN usr_machine_assign D on D.uma_machine_id = A.iif_machine_id
LEFT JOIN users E on E.usr_ID = D.uma_user_id

WHERE A.iif_feature = 'DeviceEncryption'
AND (char(D.uma_is_owner) =
(SELECT MAX(CHAR(D1.uma_is_owner)) AS uma_is_owner
 FROM usr_machine_assign D1
 WHERE D.uma_machine_id = D1.uma_machine_id)
OR D.uma_is_owner IS NULL)

ORDER BY module DESC, 'Drive Encrypted', machine, owner DESC, userID