Asset Management Suite

 View Only
  • 1.  Altiris agent query client time zone

    Posted Jun 26, 2019 04:49 AM

    Hi,

    is there a query to get the time zone of each client?

     

    Thanks



  • 2.  RE: Altiris agent query client time zone
    Best Answer

    Broadcom Employee
    Posted Jul 02, 2019 03:40 AM

    Hi ItaloDM85!

    1. By default, "Symantec Management Agent" sends own basic inventory data to Notification Server. You can check "Inv_AeX_AC_Identification" sql table and get there each managed computer 'Timezone bias' value

    Simple SQL Query to get this info

    SELECT
    Name,
    Domain,
    [System Type],
    [OS Name],
    [Timezone Bias]
    FROM Inv_AeX_AC_Identification
    ORDER BY Name
    ASC

    2. If you have "Inventory Solution" installed along with "Asset Management Suite" and you have installed "Inventory Agent" on managed client computers, then after "Gather Inventory" task execution, managed computers will send more detailed information about their Time Zone, etc from "Inv_OS_Timezone" sql table:

    Simple SQL QUery to get this info from "Inv_OS_Timezone" sql table

    SELECT * FROM Inv_OS_Timezone
    ORDER BY [Standard Name]
    ASC

    Thanks,
    IP.



  • 3.  RE: Altiris agent query client time zone

    Posted Jul 11, 2019 03:42 AM

    Thank you so much Igor!



  • 4.  RE: Altiris agent query client time zone

    Posted Jul 11, 2019 05:32 AM

    Just one last thing, please: the SQL query from [Inv_OS_Timezone] does not return the data of devices. How can I join that table considering that my main query is "FROM vComputer"?

    This is my current query:

     

    SELECT
    v1.[MAC Address],
    CONVERT(VARCHAR(10), v1.[CreatedDate], 3) AS [Discovered],
    v1.[Name],
    v1.[IP Address],
    v1.[OS Name],
    v1.[OS Version],
    [dca4_AeX AC Identification].[OS Build Number],
    v1.[System Type],
    s.[Model] [Computer Model],
    [Timezone].[Standard name],
    [Timezone].[Standard Caption],

    FROM vComputer v1

    LEFT OUTER JOIN dbo.vHWComputerSystem s
             ON (v1.Guid = s.[_ResourceGuid])

    LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
             ON (v1.Guid = [dca4_AeX AC Identification].[_ResourceGuid])
              
    WHERE v1.[MAC Address] <> ''
    ORDER BY v1.Name



  • 5.  RE: Altiris agent query client time zone

    Broadcom Employee
    Posted Jul 11, 2019 06:15 AM

    1. If you don't have any data in [Inv_OS_Timezone] sql table, then you need to install "Inventory Agent" on managed client computers and execute "Full Inventory" task to populate data in [Inv_OS_Timezone]

    https://support.symantec.com/us/en/article.howto93374.html

    2. Try your modified query below now

    SELECT
    
    v1.[MAC Address],
    CONVERT(VARCHAR(10), v1.[CreatedDate], 3) AS [Discovered],
    v1.[Name],
    v1.[IP Address],
    v1.[OS Name],
    v1.[OS Version],
    [dca4_AeX AC Identification].[OS Build Number],
    v1.[System Type],
    s.[Model] [Computer Model],
    ost.[Standard name],
    ost.[Standard Caption]
    
    FROM vComputer v1
    
    LEFT OUTER JOIN dbo.vHWComputerSystem s
             ON (v1.Guid = s.[_ResourceGuid])
    
    LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
             ON (v1.Guid = [dca4_AeX AC Identification].[_ResourceGuid])
    
    LEFT OUTER JOIN Inv_OS_Timezone ost
    ON v1.Guid = ost._ResourceGuid
    
    WHERE v1.[MAC Address] <> ''
    ORDER BY v1.Name

     

    Regards,

    IP.