Search results matching tag 'ADS input format'

RE: ACL List

LogParser User : José Gisbert — Thu, 31 May 2007 23:58:00 GMT

May be U can use Dumpacl (free) in command-line mode. Is a very usefull tool, and u can use logparser to filter/generate the report automatically, only if u want.

RE: Multiple User Object Variables

LogParser User : sa07 — Mon, 12 Feb 2007 17:23:00 GMT

Got it, I was using the wrong operators and like a dummy, the * as a wildcard instead of %. Here is the Query:

LogParser "SELECT name, userPrincipalName, userAccountControl, canonicalName INTO \\somemachine\reports\test4.csv FROM 'LDAP://domaincontroller.domain.re.xyz/ou=something,ou=something,dc=something,dc=something,dc=something,dc=something' WHERE canonicalName NOT LIKE '%/something/%'AND canonicalName NOT LIKE '%/something/%' AND userAccountControl = 512" -i:ADS -objClass:user -o:CSV

WORKS PERFECTLY!

RE: Multiple User Object Variables

LogParser User : DEinspanjer — Mon, 12 Feb 2007 16:37:00 GMT

What is an example of a canonicalName you would and would not want to match the query?

Multiple User Object Variables

LogParser User : sa07 — Mon, 12 Feb 2007 13:12:00 GMT

Hello all,

Trying to get logparser to query both an "=" and an IS NOT and I'm having a problem. Here is the base Query (which works well):

LogParser "SELECT name, userPrincipalName, userAccountControl, canonicalName INTO \\somecomputer\reports\userreport.csv FROM 'LDAP://dc.domain.blah.xyz/ou=something,ou=something,dc=something,dc=something,dc=something,dc=something' WHERE userAccountControl = 512" -i:ADS -objClass:user -o:CSV

I want to include something like "WHERE canonicalName IS NOT */*/variable/*

Any ideas?

RE: converting lastLogon to a timestamp??

LogParser User : huberse — Tue, 23 Jan 2007 14:02:00 GMT

had to try also a little time .... but here's the Result that works.

AD counts in 100 nanoseconds from 1. Jan 1601 ?!? weird somehow

SELECT TO_TIMESTAMP(ADD(DIV(TO_REAL(LastLogon), 10000000.0), TO_REAL(TIMESTAMP('1601','yyyy')))) AS [LastLogon]

best regards Serge

RE: Find Password Last Set

LogParser User : deadMETAL — Wed, 13 Dec 2006 06:47:00 GMT

Thanks very much for this, I can make use of this, I'll also use it to find old computer accounts -objClass:Computer

Thanks again

RE: Chart csv data

LogParser User : sotherls — Tue, 14 Nov 2006 18:15:00 GMT

[QUOTE User="LogParser User : sotherls"]Quote: When I try working on it I get an error of "Error: Syntax Error: : expecting FROM keyword instead of token 'c:\logparser\test\Chart.gif'" logparser -i:CSV "SELECT TOP 10 Time, Count INTO c:\logpars...[/QUOTE]

I had to modify your query to get you further along:

logparser -i:CSV "SELECT TOP 10 TS, Counts INTO c:\logparser\test\Chart.GIF FROM c:\logparser\test\log.csv ORDER by TS DESC" -charttype:bar3d

Which results in this display.

RE: Chart csv data

LogParser User : Hitchheik — Tue, 14 Nov 2006 17:38:00 GMT

When I try working on it I get an error of "Error: Syntax Error: : expecting FROM keyword instead of token 'c:\logparser\test\Chart.gif'"

logparser -i:CSV "SELECT TOP 10 Time, Count INTO c:\logparser\test\Chart.GIF FROM c:\logparser\test\log.csv ORDER by Time DESC" -charttype:bar3d

RE: Chart csv data

LogParser User : sotherls — Tue, 14 Nov 2006 17:03:00 GMT

[QUOTE User="LogParser User : sotherls"]Quote: 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-1...[/QUOTE]

Ok, to expand further.....

If I have the following dataset
TS,Counts,Server
2006-11-14 11:08:06,1,Server-1
2006-11-14 11:08:07,1966,Server-2
2006-11-14 11:10:00,3,Server-1
2006-11-14 11:10:00,1849,Server-2
2006-11-14 11:15:00,1,Server-1
2006-11-14 11:15:00,1436,Server-2
2006-11-14 11:20:00,4,Server-1
2006-11-14 11:20:00,1065,Server-2
2006-11-14 11:25:00,4,Server-1
2006-11-14 11:25:00,818,Server-2
2006-11-14 11:30:00,13,Server-1
2006-11-14 11:30:00,652,Server-2

I would like to see if I can output a chart that would show server-1's count next to server-2's count by TS (timestamp).

RE: Chart csv data

LogParser User : sotherls — Tue, 14 Nov 2006 16:27:00 GMT

[QUOTE User="LogParser User : sotherls"]Quote: 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[/QUOTE]
The query isn't the issue. It is the chart output format that is causing me grief.