DATAGRID Output Format Examples

Log Parser

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


© 2004 Microsoft Corporation. All rights reserved.