NS and DS databases
Updated: 14 Jun 2010 | 4 comments
Hello all, I have been assigned the daunting task of keeping the NS & DS Database the same.
At this point the DS and NS aren't in total sync. When running reports there is a gap of about 180 computers between these 2 databases.
In this environment, we have over 5500 computers
Can someone help me how to identify the missing number of PCs?
I will try a few fixes my-self but I will be looking for your suggestions as well
Thanks
Sam
discussion Filed Under:
Comments
If you are using v6
you could install the Deployment Solution for NS. This allows you to pull in DS Groups, and sync up multiple DS Servers with the NS. It also provides a report showing machines with the aclient and not the NS client.
Alternatively you could probably query both databases, export it to excel and do a vLookup to find the missing machines. That is alot more intensive on your part, but it depends on how fluid your environment is (rebuilds, people removing agents, etc).
The DS Solution can add significant overhead to the NS (creating the tables, collections, synching the two databases, etc), and it's fairly difficult to remove, if you decide you don't want it. In additon, if you upgrade the DS you have to upgrade the solution. However, this has been replaced in v7 with a more integrated platform, that should be fully complete by v7.1.
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
I like your suggestion but
I like your suggestion but The problem is I don't think it's possible to export data from DS to an Excel or anoy other programs although it is possible to pull reports from the NS and export to an excel spreadhseet
Sam
Run a task on all clients to chek for the other agent
Whay you need is to have a job in DS to install the Altiris Agent where it's not present (you can setup a filter to show computers without the AeXNSClient sevrice running for example) and on the NS a task to deploy the AClient if it isn't installed.
On the reporting side the best option for you is to link both servers if they are different to be able to run a report on NS to show the gap in between both systems. If they are on the same machine you don't need that as you can access the db by appending the db name "select * from eXpresss.dbo.Computers join Altiris.dbo.vComputer on ..." .
Your best tables there would be the Inv_AeX_AC_Identification in the NS db and Computers in the DS db. Join on the name and domain fields (left outer) and specify in the were close to show only entries with null (either on the left or right table in the join).
Ludovic FERRÉ
Principal Remote Product Specialist
Symantec
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect
Not natively (in Altiris) no
But you could run a query in SQL Managment Studio and copy the output to Excel.
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
Would you like to reply?
Login or Register to post your comment.