DATAGRID Output Format Examples

Users' Job Titles

Retrieve users' job title breakdown from Active Directory:

LogParser "SELECT title, MUL(PROPCOUNT(*), 100.0) AS Percentage INTO DATAGRID FROM 'LDAP://MyUsername:MyPassword@mydomain/CN=Users,DC=mydomain,DC=com' WHERE title IS NOT NULL GROUP BY title ORDER BY Percentage DESC" -objClass:User

Registry Type Distribution

Display the distribution of registry value types:

LogParser "SELECT ValueType, COUNT(*) FROM \HKLM GROUP BY ValueType" -o:DATAGRID