ADS Input 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

IIS AccessFlags MetaBase Properties

Retrieve all the AccessFlags properties from IIS metabase objects:

LogParser "SELECT ObjectPath, PropertyValue FROM IIS://localhost WHERE PropertyName = 'AccessFlags'"