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

How to fetch the report from NS server?

Created: 04 Dec 2012 | 25 comments

Hi

can you please let us know how I can fetch all computer details which are having Altiris in .txt format?

Comments 25 CommentsJump to latest comment

JimChud's picture

Go to Reports on the top bar.
Select All Reports.
Go to Discovery and Inventory > Inventory.
Select the report called Discovered Devices.  This report shows all machines that are discovered by Altiris by network inventory or agent inventory.

Once this has loaded press 'Save As' and select Spreadsheet.

this will export it in to a CSV file which is a plain text file like a .txt open in notepad or excel or whatever you want.

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

Nagesh Singh's picture

Unable to find the option please suggest.

Thanks & Regards,

Nagesh Singh

 

Alex Bizjajev's picture

I believe JimChud talking about this report\option:

Alex Bizjajev's picture

Also, if you are looking for the computers with Altiris Agent installed then maybe more proper report is: Reports -> Notification Server Management -> Agent -> Computers with Agent Installed.

Nagesh Singh's picture

Is it possible to get the system report with current login user ID?

Thanks & Regards,

Nagesh Singh

 

Alex Bizjajev's picture

Try "Reports -> Notification Server Management" -> Server -> Resource Reports -> Computers". This report contains primary user name; in most cases this will correspond the logged-on user name. NS stores "Last Logon user" name in the database, but to see it you will need to perform some modifications to report.

Also, you may see "Is managed" flag in the Computers report - you may use this flag to sort the computers with and without Altiris Agents, as "Managed=1" means Altiris Agent is installed.

Thank you,

Alex.

Nagesh Singh's picture

Hi Alex,

 

Can you please share teh SQL query for the same?

Thanks & Regards,

Nagesh Singh

 

Alex Bizjajev's picture

Please check the xml attached to this post - this is the export of modified "computers" report, column "Last Logon User" added next to the "User" column. Right-click to the "Resource Reports" folder, select "Import" and import this xml. After that you should see report with name "Computers-with-last-logon-user" in console. Hopefully, this is the info you are looking for.

Thank you,

Alex.

AttachmentSize
Computers-with-last-logon-user.xml 40.54 KB
Nagesh Singh's picture

Thanks Alex,

  1. I have imported the Policy and checking.
  2. We used to pushing a MS Vulnerability patch through NS server every second week of Wednesday in a month. Now if I want to get the report for how many system got the same patch then  how it’s could be done and where we will get that report?

Thanks & Regards,

Nagesh Singh

 

Roman Vassiljev's picture

Hi Nagesh,

If you need to see how many system got the same patch, please navigate to 'Windows Software Update Delivery - Details' report, right-click on required update and open 'View Targeted Computers by Update' drill down report.

'Windows Software Update Delivery - Details' report is located at Reports > Software > Patch Management > Remediation Status

Thanks,
Roman

Nagesh Singh's picture

Thanks Alex,

and If I want to get all the system where Symantec management agent is not install?

Thanks & Regards,

Nagesh Singh

 

Alex Bizjajev's picture

In this case report "Agents Not Installed in the last N Days" should provide needed info (this report based on discovered devices table)

zafar1907's picture

Hi Alex,

 I want the softeare inventory of all managed system in Excel.I am able to do this one by one ,but i want all report at once.

Thanks and Regards,

Mohammad zafar

Please Mark as solution if this comment solved your Issue....

Alex Bizjajev's picture

Hi Mohammad,

Please take a look at: "Reports -> Discovery and Inventory -> Inventory -> Cross-paltform -> Software/Applications -> Software -> Installed Software by Computer" report.

By defaule this report should display "Managed" software for all computers. If you change drop-down "Type" selection to "All software" and press "Refresh" then you should see all the software, installed on the computers with Altiris Agent. Select "Save As -> SpreadSheet" and open the resulting table in Excel.

Thank you,

Alex.

Nagesh Singh's picture

Hi,

If support I want to fetch the report of the system which are not having Symantec Endpoint protection through Altiris 7.1  then How I can do that?

Thanks & Regards,

Nagesh Singh

 

Alex Bizjajev's picture

Hi Nagesh,

Do you have Symantec Endpont Protection Integration Component installed in your implementation of Altiris ? (it's a part of Client Management Suite, so I suppose you should have).

Please check the SEPIC reports in "Reports -> Symantec Endpont Protection Management". Specifically "Details of unmanaged, managed unprotected and managed protected machines" report. If you select "Managed and Unprotected" in "Type" drop-down and hit Refresh then this report should display all the clients without antivirus installed.

Thank you,

Alex.

Nagesh Singh's picture

Hi Alex,

Thanks

  1. Yes we have installed IT analysis which is integrating my SEP server with Altiris server?
  2. Secondly is it possible to us to check add and remote program of all the system where we do have Altiris agent but not having Symantec Endpoint protection”

Please suggest best way to fetch the report?

Thanks & Regards,

Nagesh Singh

 

zafar1907's picture

Alex,

I know what you suggest  this is only for one system.But I want the report of all 8000 machines,so what should I do,Plz sugggest.

 

Thanks

Thanks and Regards,

Mohammad zafar

Please Mark as solution if this comment solved your Issue....

Alex Bizjajev's picture

Hi Mohammad,

It's really strange if this report returns only one computer in your environment, as it shold return all. Please task a look at attached screen - this is a results of running the report in my environment. As you may see, different computers are listed:

Nagesh Singh's picture

Hi all,

Can we have Client management suite (CMS) administrator Guide through which we can read all the options available in CMS (7.1) and above?

Thanks & Regards,

Nagesh Singh

 

Nagesh Singh's picture

Thanks Alex,

Can you please let us know what is the latest version release for Symantec management agent?

Thanks & Regards,

Nagesh Singh

 

Alex Bizjajev's picture

The latest release at the moment is 7.1.SP2 MP1.1 and full version of SMA in this release is: 7.1.15400.8400.

Below is a screen-shot from XP computer with 7.1.SP2 MP1.1 release and most of ITMS plugins:

 

zafar1907's picture

Hi Alex,

I am getting these all but , I want different report of different machine like

ts0364-01, should be in different excel sheet

win7-client, is in different excel sheet and so on......

Thanks and Regards,

Mohammad zafar

Please Mark as solution if this comment solved your Issue....

Alex Bizjajev's picture

Hi Mohammad,

Unfortunately, I do not have a quick answer how to handle such task by report. Probably it should be  possible to create an excel macros, that will parse resulting excel and copy records with the same computer name to the corresponding sheet.

Thank you,

Alex.