Asset Management Suite

Hi All

We are running Symantec management platform 7

Notification server 7.

We use OSD to image our machines and currently our import file for these puts the MAc address of the machine into a custom table which our OSD process then uses to collect the mac address for the machine.

This is a static table and we have now encountered the problem that when we have a board change this field is not updated but Altiris is updating the Inv_Aex_AC_TCPIP table with the new MAc address.

We have found the TCPIP data class in the settings section of the console but it is under the basic inventory area which is not assignable to a resource type.

We would like to know if there is a way of importing the MAC address of a new PC directly into the TCPIP table without having to use the static table we had to create to use OSD.

If I understand you correctly, you currently use a custom table for OSD, which has MAC address populated by an import file you receive with your new computers.  Because this custom table is not updated when MAC addresses change (e.g. motherboard replacements), you want to instead use the Inv_AeX_AC_TCPIP table.  But because the Inv_AeX_AC_TCPIP table doesn't include new computers, you want to also populate it from the static file.  Is that right?

Hi mclemson

Yes that is correct. thanks for taking the time to look at my post

Can you use both?  I'm not sure how OSD is accessing the custom table, but let's say you key on computer name.  You current query might be:

SELECT Name, [MAC Address] FROM Inv_Custom_OSD WHERE <whatever>

You could modify this to be:

SELECT vc.Name, tcpip.[MAC Address]
FROM vComputer vc
JOIN Inv_AeX_AC_TCPIP tcpip ON tcpip._ResourceGuid=vc.Guid
WHERE vc.Name IN (SELECT Name FROM Inv_Custom_OSD)
--The above SQL returns name and MAC address for computers from Altiris, if they exist in both Altiris and the custom OSD table

UNION

--..and combines it..
SELECT osd.Name, osd.[MAC Address] FROM Inv_Custom_OSD
WHERE osd.Name NOT IN (
SELECT vc.Name
FROM vComputer vc
JOIN Inv_AeX_AC_TCPIP tcpip ON tcpip._ResourceGuid=vc.Guid
WHERE tcpip.[MAC Address] IS NOT NULL)
--with this SQL, which returns Name and MAC address for computers in the custom OSD table who do not have a MAC address recorded in Altiris

I don't have the custom table, so I haven't run this, but it should return a single list of computers, with MAC address from Altiris if there, otherwise from the custom static table.

Thanks for all the help detailed above. We have now got a task which runs to update the OSD mac address with the latest received inventoried MAC address.

This has solved our little problem.