Solved

Export Symantec client details

Posted on 2014-03-03
8
1,229 Views
Last Modified: 2014-03-10
I am running Symantec protection manager with various managed clients. On the clients tab if I open the client it gives me some really great detail about the OS, memory, user etc. Is there anyway to export all this data out to a CSV file or something.
I have tried going into the search client and exporting to CSV there but it only exports three columns. Is it possible to export all?
0
Comment
Question by:Sid_F
  • 5
  • 3
8 Comments
 
LVL 61

Expert Comment

by:btan
ID: 39903106
I believe these below are close to what you looking for and it stated there is no way to automatically create and save a specific report in .csv format either via SEPM or Protection Center. There is some script and even drilling into database schema query to overcome that though. Good if you can look at the links where it is from the log to get the info..

"Export to CSV/txt file monitors tab logs SEP Manager"
http://www.symantec.com/connect/forums/export-csvtxt-file-monitors-tab-logs-sep-manager

"Export SEPM reports to CSV or Excel"
http://www.symantec.com/connect/forums/export-sepm-reports-csv-or-excel

In the same light if a report can be generated with the info and from there export it out, it is another way (manual though). Some of the available reports are as stated in below. E.g. under "Computer Status Reports", it includes "Client Inventory". This may need some "playing" around to see if it can target specific client.

"About the different types of Symantec Endpoint Protection Manager Reports"
http://www.symantec.com/business/support/index?page=content&id=TECH95538

Note earlier there is link leading to the below too
"Trick to export customized reports from Symantec endpoint Manager"
http://www.symantec.com/connect/articles/trick-export-customized-reports-symantec-endpoint

"Making a report in Symantec Endpoint Protection Manager that will show client names, IP address, and Client Versions."
http://www.symantec.com/business/support/index?page=content&id=TECH104852

I was even thinking probably the copy and paste into excel may be a quicker method if the machine is small list, it is tedious but may be rudimentary to worth the tie comparing to searching the ideal solution.

Have the support to address or even post to the Symantec forum to get some advice too since the newer version may have further enhancement already, I doubt we are the first
0
 
LVL 5

Author Comment

by:Sid_F
ID: 39904779
1)Ok to be specific about what I want to do. When I go to clients if I select the top level "my company" there are no clients displayed under client status. I have to drill down further and select the sub folders for clients to display.. is this correct or should I be able to see all clients in sub folders by selecting the top level folder.

2)On a folder that does have clients if I select client system from the drop down it displays all the required information that I want but how do I export this information.

If I can find this out then I have everything I need.
0
 
LVL 5

Author Comment

by:Sid_F
ID: 39904865
I think I found what I need using the reports section, select computer status as report type, then select client inventory for select a report and set a date of a few weeks to capture all machines. It gives a nice graph to a mht format.
The question is how to get more granular reporting like being able to get all XP machines with their IP addresses and export to a CSV file.
0
 
LVL 61

Expert Comment

by:btan
ID: 39905223
As in my earlier post, the symantec tech support already shared there is no way to automatically create and save a specific report in .csv format either via SEPM or Protection Center. The report as also mentioned in the posting does have the computer status but not any further granularity.

If i will to extract below from the posting in forum as below

http://www.symantec.com/business/support/index?page=content&id=HOWTO27263

Exporting log data
You have several choices for exporting the data in your logs. You can export the data in some logs to a comma-delimited text file. You can export other logs' data to a tab-delimited text file that is called a dump file or to a Syslog server. Log data export is useful if you want to accumulate all logs from your entire network in a centralized location. Log data export is also useful if you want to use a third-party program such as a spreadsheet to organize or manipulate the data. You also might want to export the data in your logs before you delete log records.

When you export log data to a Syslog server, you must configure the Syslog server to receive those logs. To forward logs to third-party programs, you need to have the third-party program installed and on the network. For example, you can use Microsoft Excel to open the exported log files. Each field appears in a separate column, a separate log record in each line.

Note:  You cannot restore the database by using exported log data.

Exporting log data to a comma-delimited text file
Exporting data to a Syslog server
Exporting log data to a text file

There is another earlier link but this touch schema though but I believe it can give you the granularity provided we know the schema

Export - http://www.symantec.com/connect/articles/trick-export-customized-reports-symantec-endpoint

Schema - http://www.symantec.com/business/support/index?page=content&id=TECH102544

About log types - http://www.symantec.com/business/support/index?page=content&id=HOWTO27271
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 5

Accepted Solution

by:
Sid_F earned 0 total points
ID: 39905737
I appreciate your help, my question is specific and I wanted to get the answer with the least amount of pain. I can google and search Symantec forums, trawling through posts trying to extract the relevant data from forums of which quite a lot will either be unrelated or make things very complicated to get simple data. For the next person looking for this data the exact steps to get the data is below.

Go to the reports tab, select computer status as report type and client inventory as the report.. set the time range for past month to be sure you are capturing all data.

Click advanced setting and select the criteria eg Windows XP- click to save the filter giving it an easily identifiable name.. At this point you can create the report which will display in a webpage in a nice pie chart however it cannot be exported to CSV file in this area.

To export to CSV file go to monitors and then logs, select computer status as the report type, in use a saved filter click the drop down box and you will see your previous saved filter, once this is selected it will change the time range- select view log and then select export which will give you the CSV.

This will give you a considerable amount of data relating to all your clients and is an excellent source for getting an overview of what XP machines can or cannot be upgraded.
0
 
LVL 61

Expert Comment

by:btan
ID: 39906168
thanks for sharing. well received
0
 
LVL 5

Author Comment

by:Sid_F
ID: 39906666
Much appreciated.
0
 
LVL 5

Author Closing Comment

by:Sid_F
ID: 39917020
Issue resolved
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

OVERVIEW This guide provides information on the process performed when the Symantec Endpoint Protection (SEP) client checks in with the Symantec Endpoint Protection Manager (SEPM). AUDIENCE Information Technology personnel responsible for suppo…
HOW TO REMOTELY CLEAN MEROND.O WITH ESET SILENTLY PROBLEM       If you have the fortunate luck to contract the Merond.O virus on your network, it can be quite troublesome to remove as it propagates to network shares on your network. In my case, the …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now