K
kjmatt
I'm generating charts from a series of XML files using LogParser. One of the
XML fields is a file size. I'm summing the file sizes based on the Userid.
The problem is that when the summed numbers approach 2 gigabytes they start
going negative on the chart, so I end up with a chart with both positive and
negative bars. If I output to a CSV file the numbers are all positive, so I'm
thinking that it must be something with the way the chart itself is
generated. Here is a sample query:
logparser -i:xml -o:chart "select User, sum(size) as sumSize into
Fileslast30.jpg from \iislogfiles\*.xml where User like 'PA%' and Date >
'20090109' or User like 'NY%' and Date > '20090109' or User like 'GA%' and
Date > '20090109' or User like 'CA%' and Date > '20090109' or User like
'NV%' and Date > '20090109' or User like 'WA%' and Date > '20090109' or User
like 'NC%' and Date > '20090109' or User like 'AL%' and Date > '20090109' or
User like 'MO%' and Date > '20090109' group by User order by sumSize desc"
-charttype:barclustered3d -charttitle:"Files Transferred Last 30"
-groupsize:800x600 -fmode:tree
Unfortunately I am unable to submit any sample data as it is not for public
viewing and don't have a screen shot.
Any help is appreciated
KJ
XML fields is a file size. I'm summing the file sizes based on the Userid.
The problem is that when the summed numbers approach 2 gigabytes they start
going negative on the chart, so I end up with a chart with both positive and
negative bars. If I output to a CSV file the numbers are all positive, so I'm
thinking that it must be something with the way the chart itself is
generated. Here is a sample query:
logparser -i:xml -o:chart "select User, sum(size) as sumSize into
Fileslast30.jpg from \iislogfiles\*.xml where User like 'PA%' and Date >
'20090109' or User like 'NY%' and Date > '20090109' or User like 'GA%' and
Date > '20090109' or User like 'CA%' and Date > '20090109' or User like
'NV%' and Date > '20090109' or User like 'WA%' and Date > '20090109' or User
like 'NC%' and Date > '20090109' or User like 'AL%' and Date > '20090109' or
User like 'MO%' and Date > '20090109' group by User order by sumSize desc"
-charttype:barclustered3d -charttitle:"Files Transferred Last 30"
-groupsize:800x600 -fmode:tree
Unfortunately I am unable to submit any sample data as it is not for public
viewing and don't have a screen shot.
Any help is appreciated
KJ