Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

How to create an exporting customiz data

Updated: 04 Jan 2010 | 1 comment
dsi-cspi-soc@gdfsuez.com's picture
1 Agree
0 Disagree
+1 1 Vote
Login to vote
Status: Reviewed

Hi,

I am trying to figure out how to create a custom report in SEPM. I can't create a filter for what I want and the report where I am trying to create does not exist.
I can show the information that i want when i select Logs, Computer Status but i can't create a schedule report with the same informations.

I would like to schedule the report for show this informations:
 

Version Operating System Client Version Status Last Update Time Auto-Protect on Infected Antivirus engine on Network Threat Protection On Group Name Computer Name Computer Domain Name IP Address1

Anyone have any suggestions?

Thanks !

Comments

fxsti01's picture
22
Dec
2009
1 Vote +1
Login to vote

Please see forum link,

Please see forum link, https://www-secure.symantec.com/connect/forums/exporting-console-data-txt-or-csv
We just installed version 11 ru5, and it also has the same reports as earlier versions, just charts, pie graphs, no actual details as to who (which computers are having the issues.)

I have been going in everyday, doing a manual export of the Computer Status logs (as stated above) from the SEP console.  Then open it up in excel to "save as" csv file, then manually importing it into Access to reconcile against Active Directory exports and our Asset Management exports.  After that I am manually creating queries to report out numbers of pc's and which pc's are having issues.

Currently I am talking to our DB techs to see if we can get all this data into SQL and schedule the running of queries to try and automate this whole process!!!!!

It would be a MAJOR MAJOR time saver if we were able to schedule the running and exporting of logs out of the SEP console.