Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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