Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Export or Save Report Files to Excel

Created: 25 Oct 2011 • Updated: 25 Oct 2011 | 3 comments
AHSecurity's picture
4 Agree
0 Disagree
+4 4 Votes
Login to vote

It would be helpful if the report files could be exported to an excel file and or a text file. Example - I have three campus with 6 different techs, if I have 60 PC on the Out of Date report, I would like to export it to a excel file so I could manipulate the data so that all workstation identified could be sent to the same campaus. Right now we can only save it to a HTML file which allows for no manipulation.

Comments 3 CommentsJump to latest comment

deepak.vasudevan's picture

I second it and also would like a PDF export option too.

-1
Login to vote
Tmy_70's picture

I can do that with unix and awk, let me know if you have a unix system

iconv -f utf16 -t iso8859-1 /home/tms/CAF_doc/21.10.2011/p1.txt > /home/tms/CAF_doc/21.10.2011/1.txt
iconv -f utf16 -t iso8859-1 /home/tms/CAF_doc/21.10.2011/p2.txt > /home/tms/CAF_doc/21.10.2011/2.txt
iconv -f utf16 -t iso8859-1 /home/tms/CAF_doc/21.10.2011/p3.txt > /home/tms/CAF_doc/21.10.2011/3.txt
iconv -f utf16 -t iso8859-1 /home/tms/CAF_doc/21.10.2011/p4.txt > /home/tms/CAF_doc/21.10.2011/4.txt
iconv -f utf16 -t iso8859-1 /home/tms/CAF_doc/21.10.2011/p5.txt > /home/tms/CAF_doc/21.10.2011/5.txt
unzip /home/tms/CAF_doc/21.10.2011/5746*.zip
unzip /home/tms/CAF_doc/21.10.2011/5745*.zip
unzip /home/tms/CAF_doc/21.10.2011/7500*.zip
mv /home/tms/CAF_doc/21.10.2011/5746*.xls /home/tms/CAF_doc/21.10.2011/summary-completed.xls
mv /home/tms/CAF_doc/21.10.2011/5745*.xls /home/tms/CAF_doc/21.10.2011/summary-failed.xls
mv /home/tms/CAF_doc/21.10.2011/7500*.xls /home/tms/CAF_doc/21.10.2011/volumes-capacity.xls
mv /home/tms/CAF_doc/21.10.2011/Dataset_VENFFPR5*.txt /home/tms/CAF_doc/21.10.2011/VENFFPR5.txt
mv /home/tms/CAF_doc/21.10.2011/Dataset_VENFFPR4*.txt /home/tms/CAF_doc/21.10.2011/VENFFPR4.txt
mv /home/tms/CAF_doc/21.10.2011/Dataset_VENFFPR3*.txt /home/tms/CAF_doc/21.10.2011/VENFFPR3.txt
mv /home/tms/CAF_doc/21.10.2011/Dataset_VENFFPR2*.txt /home/tms/CAF_doc/21.10.2011/VENFFPR2.txt
cat /home/tms/CAF_doc/21.10.2011/ciclope.txt | egrep -i "NetWorker savegroup: |Restart time: |Start time: |End time: |savegrp is already running| Failed: Succeeded with warning(s): "|  awk '{ print $4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19}'>> salida.txt && cat /home/tms/CAF_doc/21.10.2011/aros.txt | egrep -i "NetWorker savegroup: |Restart time: |Start time: |End time: |savegrp is already running| Failed: Succeeded with warning(s): " | awk '{ print $4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19}'>> salida.txt
cat /home/tms/CAF_doc/21.10.2011/VENFFPR2.txt | egrep -i "Starting backup of dataset|Backup task: completed |Backup task failed to succeed." | awk '{ print "VENFFPR2",$2,"p.m.",$5,$6,$7,$8}'>> salida.txt
cat /home/tms/CAF_doc/21.10.2011/VENFFPR3.txt | egrep -i "Starting backup of dataset|Backup task: completed |Backup task failed to succeed." | awk '{ print "VENFFPR3",$2,"p.m.",$5,$6,$7,$8}'>> salida.txt
cat /home/tms/CAF_doc/21.10.2011/VENFFPR4.txt | egrep -i "Starting backup of dataset|Backup task: completed |Backup task failed to succeed." | awk '{ print "VENFFPR4",$2,"p.m.",$5,$6,$7,$8}'>> salida.txt
cat /home/tms/CAF_doc/21.10.2011/VENFFPR5.txt | egrep -i "Starting backup of dataset|Backup task: completed |Backup task failed to succeed." | awk '{ print "VENFFPR5",$2,"p.m.",$5,$6,$7,$8}'>> salida.txt
cat /home/tms/CAF_doc/21.10.2011/volumes-capacity.xls | head | awk '{ print $2,$4,($5/1024)/1024,($6/1024)/1024, $7 }'>> salida.txt

If this post has helped you, please vote or mark as solution. MBA. TC Venezuela Consultor Power

-1
Login to vote
pbishop@ikasystems.com's picture

...this might be resolved under BE2012 - but it would be a nice feature to be able to access the BE database (read-only of course), them pull the needed info out using Powershell.

Currently I copy / paste the info from the Job History info Excel, then massage it from there.

Pete

-1
Login to vote