What are you having trouble with? The query or the chart? The query should be something along the lines of: SELECT TOP 10 Time, Count FROM log ORDER by Time DESC

THis should be soooo simple but it isn't - yet. Help! I have a csv file which has data similar to this: TIME,COUNTed 2006-11-09 13:51:24,3279 2006-11-09 13:56:24,3285 2006-11-09 14:01:24,3295 2006-11-09 14:06:24,3000..... I want to simply have a chart that depicts the last ten events in the log similar...

LogParser.exe -objClass:USER "Select employeeID,sAMAccountName as ID,name as FullName,givenName as FirstName,MiddleName,sn as LastName,ObjectPath,Description into ADusers.csv from 'LDAP://%USERDNSDOMAIN%/dc=%UserDomain%,dc=COM' where LastName is NOT null ORDER BY employeeID,samAccountName"

I need to run a query to get a list of all of my users. I'm running into a problem since they are spread out among various OU's. Is there anyway to have LP query the entire domain for the users without have to do a query for each OU? We are in a Windows 2003 SP1 AD environment. Thanks in advance.

Can I use the ADS Input Format to query a generic (non-AD) LDAP directory? I've made some attempts, but not yet had success. If so, any pointers on syntax? Thanks.

accountExpires accountNameHistory aCSPolicyName adminCount adminDescription adminDisplayName allowedAttributes allowedAttributesEffective allowedChildClasses allowedChildClassesEffective altRecipient altRecipientBL altSecurityIdentities assistant attributeCertificate authOrig authOrigBL autoReply autoReplyMessage...

Search the forums for the term epoch. You'll find a post from me with a reply from Gabriel about the best way to handle that type of timestamp.

it's a timestamp in the Active Directory for the last time the user logged on to the domain. It seems to be in seconds or something. In adsiedit, the attribute is listed with a syntax description of Large Interger/Interval

I'm not familiar with the input format you are using. What is the raw format of the lastLogon field? Is it a date string or an int or what?

My query: C:\Program Files\Log Parser 2.2>logparser "SELECT displayName,cn,description,mail,whenCreated,whenCh anged,lastLogon FROM LDAP://domain.com/DC=domain,DC=com" -i:ADS -o ATAGRID -objClass:User returns something like 127934555069865000.00 for lastLogon. Tried C:\Program Files\Log Parser 2.2>logparser...