Client Management Suite

Does anyone know if the Altiris DB keeps track of the IP address for each computer?  If so, does it keep track of the IP address for each day/time or for each time it changed?  If needed to pull a report on a specific computer and wanted to view the IP address for certain days/times; would this be possible with Altiris?

Has someone done this before?  Would someone know how to run a report on this?

I want to return the IP address of a certain computer name on certain day(s) along with the time.  

If someone could help then I would much appreciate it! 

Thank you
 

 in Notification Server, the table that gives you IP info is Inv_AeX_AC_TCPIP, and the History Table Name is InvHist_AeX_AC_TCPIP. You might be able to write a query that looks into the history table to get that data for a given computer.

That's good know, I'm not sure much of a scriptor would someone know how to query this information?

Thanks!

I'm trying to use the InvHist_AeX_AC_TCPIP table but I'm getting an error that it's an invalid object.  Is this the correct table?

I'm trying to use the InvHist_AeX_AC_TCPIP table but I'm getting an error that it's an invalid object.  Is this the correct table?

 I just searched for Connect for "inventory history table" and found this relevant link https://www-secure.symantec.com/connect/articles/tracking-changes-inventory-solution-data-using-history-tables. This might be what you are looking for.

Fmora,

If you are getting an "invalid object" error, this means you have yet to enable history for the TCPIP properties.  The link provided in the post above gives some very good information about the history tables.  The article uses an example of Add_Remove_Programs, but can easily be applied to TCPIP.

You would first need to enable history on this object (table) by going to "Configuration --> Server Settings --> Notification Server Settings --> Resource History --> Basic Inventory --> Aex AC TCPIP", check the box and set the purging schedule.  Once this occurs, the table should be automatically generate and you will be able to query against that table.

So, for now at least, you are out of luck on getting historical IP data.  However, if you just need to get IP address of the machine from its last inventory, you can simply add [IP Address] to your query.  I used the example of the user logins from the other post to give you an example with using c.[IP address].

SELECT c.Name, c.[Ip Address], cl.Event, cl.[User], cl.Domain, cl.Time
FROM vComputer c
INNER JOIN Evt_AeX_Client_LogOn cl ON cl._ResourceGuid = c.Guid
WHERE CONVERT(CHAR(10),cl.Time,101) BETWEEN '07/14/2009' AND '07/14/2009'
AND CONVERT(CHAR(10),cl.Time,114) BETWEEN '14:00' AND '16:00'
AND c.Guid IN (
SELECT c.ResourceGuid
FROM CollectionMembership c
INNER JOIN [vItem] i ON c.CollectionGuid = i.Guid
WHERE i.Name IN ('CollectionName', 'SecondCollectionName')
)
-- AND c.Name = 'ComputerName'
-- AND cl.Event = 'Logon'
ORDER BY cl.Time

RS