Asset Management Suite

 View Only
  • 1.  Altiris Report For All Apple Mac Machines

    Posted Oct 03, 2014 03:57 PM

    Need help with SQL query report in Altiris 7.1 that can provide all Apple Mac machines, OS X version, IP addresss, Location, User Name.

     

    Thanks,

     

     



  • 2.  RE: Altiris Report For All Apple Mac Machines

    Posted Oct 09, 2014 01:19 AM

    You can sort the data and move the mac information

    SELECT dbo.Inv_AeX_AC_Identification.[Name][Host Name]
    , dbo.Inv_AeX_AC_Identification.[Os Name]
    , dbo.Inv_AeX_AC_Identification.[System Type]
    , dbo.Inv_AeX_AC_Identification.[Last Logon User]
    , dbo.Inv_AeX_AC_TCPIP.[IP Address]
    , dbo.Inv_SW_BIOS_Element.[Version][BIOS Version]

    FROM
    dbo.Inv_AeX_AC_Identification,
    dbo.Inv_AeX_AC_TCPIP,
    dbo.Inv_SW_BIOS_Element

    WHERE
    dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_AeX_AC_TCPIP._ResourceGuid
    AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid



  • 3.  RE: Altiris Report For All Apple Mac Machines

    Posted Oct 09, 2014 09:31 AM

    Here is another query which also provides the OS version.  You asked for location but I'm not sure what you mean by that.  Do you store a location in the asset system or are you looking for something like the current site (based on IP address)?

    SELECT vc.Name [Computer Name]
    , vc.[User]
    , vc.[Os Name]
    , vc.[OS Version]
    , vc.[OS Revision]
    , vc.[IP Address]
    , bios.[Version] [Bios Ver]
    , id.[Hardware Serial Number]
    , vc.IsManaged

    FROM vComputer vc
    LEFT JOIN Inv_AeX_AC_Identification ID on ID._ResourceGuid = vc.Guid
    LEFT JOIN Inv_SW_BIOS_Element bios on bios._ResourceGuid = vc.Guid

    WHERE
    vc.[OS Name] like 'Mac OS%'

    ORDER BY
    vc.Name



  • 4.  RE: Altiris Report For All Apple Mac Machines

    Posted Oct 13, 2014 11:29 PM

    Thank you both, i got it and both queries did the job.



  • 5.  RE: Altiris Report For All Apple Mac Machines

    Posted Oct 14, 2014 10:21 AM

    Actually I need  more information that is missing from the provided queries. I need to get the name of the Apple Mac machines, User Name, OS X version, IP addresss, Serial number, Model Number, Manufacturer where Manufacturer is Apple . The MAC Book machines are not reporting their information and they also have Windows 7 partition that is installed so would be helpful to get as well.

     



  • 6.  RE: Altiris Report For All Apple Mac Machines
    Best Answer

    Posted Oct 15, 2014 02:42 PM

    Here is the query with Mfgr / Model added.

    I'm not sure what you mean about a Windows 7 partition.  Assuming you mean dual booting or running Win 7 as a virtual like under Parrallels, you would need to install the Altiris agent separatly within Windows 7, you wouldn't be able to inventory any Win 7 information from the Mac agent.  If you are dual-booting (using the same NIC with the same MAC address), I would imagine you might have some resource merging issues as well where Altiris goes back and forth reporting whether the machine is Windows or Mac OS.  If you are running Windows as a VM, Altiris will see it as a separate resource.

    SELECT vc.Name [Computer Name]

    , vc.[User]
    , vc.[Os Name]
    , vc.[OS Version]
    , vc.[OS Revision]
    , vc.[IP Address]
    , bios.[Version] [Bios Ver]
    , sn1.[Manufacturer]
    , sn1.[Model]
    , id.[Hardware Serial Number]
    , vc.IsManaged

    FROM vComputer vc
    LEFT JOIN Inv_AeX_AC_Identification ID on ID._ResourceGuid = vc.Guid
    LEFT JOIN Inv_SW_BIOS_Element bios on bios._ResourceGuid = vc.Guid
    LEFT JOIN vHWComputerSystem sn1 ON sn1.[_ResourceGuid] = vc.Guid

    WHERE

    vc.[OS Name] like 'Mac OS%'

    ORDER BY

    vc.Name

     

    Joe