DATAGRID Output Format Examples

Log Parser

previous page next page

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.

previous page start next page