Client Management Suite

 View Only
  • 1.  Machine modele report

    Posted Apr 13, 2012 05:54 AM

    I need to display in a report the modele of the machines of my parc. I have the information on the inventories of the machine example : Latitude E5520 but when I want to display it in a report as [Manufacturer].[Model] it displays only blank fields with no information.



  • 2.  RE: Machine modele report

    Posted Apr 13, 2012 08:45 AM

    Hi Green,

    Do you have results with Reports\Discovery and Inventory\Inventory\Cross-platform\Hardware\Hardware Inventory Search report?

    Sure you have the Inventory Hardware policy running in your clients.

    Regards



  • 3.  RE: Machine modele report

    Posted Apr 13, 2012 09:36 AM

    Thanks for your reply.

    Yes I have the information on the report you suggest me Here below is the sql version of this report  :

    /*SELECT DISTINCT
        i.[Guid],
        i.[Name][Computer Name],
        i.[Domain],
        s.[Identifying Number] [Serial Number],
        s.[Identifying Number]  [Asset Tag],                
        s.[Manufacturer] [System Manufacturer],
        s.[Model] [Computer Model],
        i.[System Type][Computer Type],
        d.[Unique ID][UUID],
        ltrim(rtrim(str([SMBIOS Major Version])))  + '.' + ltrim(rtrim(str([SMBIOS Minor Version])))[SMBIOS Version],
     CASE
        WHEN b.[_ResourceGuid]IS NOT NULL  THEN   'ENABLED'  
           ELSE 'DISABLED'
        END [SMBIOS Enabled]        
    FROM dbo.vComputer i  
        JOIN dbo.vHWComputerSystem s
        ON s.[_ResourceGuid]=i.Guid
         JOIN dbo.vSWSMBIOSElement b
        ON b.[_ResourceGuid]=s.[_ResourceGuid]
        JOIN dbo.Inv_AeX_AC_Identification d  
            ON d.[_ResourceGuid] = i.Guid
        JOIN dbo.CollectionMembership cm  
            ON cm.[ResourceGuid] = d.[_ResourceGuid]
        JOIN dbo.vCollection it  
            ON it.Guid = cm.CollectionGuid  
       AND d.[System Type] LIKE '%Computer Type%'  
         AND LOWER (i.[Name]) LIKE LOWER ('%ComputerName%')   
        AND LOWER (s.[Manufacturer]) LIKE LOWER ('%Manufacturer%')
        AND LOWER (s.[Model]) LIKE LOWER ('%Model%')*/

    DECLARE @v1_TrusteeScope nvarchar(max)
    SET @v1_TrusteeScope = N'%TrusteeScope%'
    SELECT DISTINCT i.Guid,
    i.Name [Computer Name],
    i.Domain [Domain],
    cs.[Identifying Number] [Serial Number],
    be.[Identification Code] [Asset Tag],
    cs.Manufacturer [System Manufacturer],
    cs.Model [Computer Model],
    i.[System Type] [Computer Type],
    d.[Unique ID] [UUID],
    CASE WHEN be._ResourceGuid IS NOT NULL THEN 'ENABLED' ELSE 'DISABLED' END [SMBIOS Enabled],
    ltrim(rtrim(str([SMBIOS Major Version])))  + '.' + ltrim(rtrim(str([SMBIOS Minor Version])))[SMBIOS Version],
    'ENABLED' [DMI Enabled],
    '' [DMI Version]
    FROM dbo.vComputer i
    JOIN dbo.ScopeMembership sm
        ON sm.[ResourceGuid] = i.Guid
        AND sm.[ScopeCollectionGuid] IN (SELECT * FROM dbo.fnGetTrusteeScopeCollections (@v1_TrusteeScope))
    LEFT JOIN dbo.Inv_AeX_AC_Identification d
        ON d._ResourceGuid = i.Guid
    JOIN dbo.vHWComputerSystem cs
        ON i.Guid = cs._ResourceGuid
    LEFT JOIN dbo.vSWBIOSElement be
        ON be._ResourceGuid = i.Guid
    LEFT JOIN dbo.vSWSMBIOSElement sbe
        ON sbe._ResourceGuid = i.Guid
    WHERE i.Name LIKE '%Computer Name%'
    AND cs.Manufacturer LIKE '%Manufacturer%'
    AND cs.Model LIKE '%Model%'
    AND i.[System Type] LIKE '%Computer Type%'

     

    but when I want to display the same information by using the report builder, the field which interest me is in bold Model [Computer Model] I didn't find any way to display the good information. As I am not a sql specialist and as Symantec has sold the report builder to give us the possibility to create custom reports

     

    When I am using report builder HEre below is the sql query created  :

    SELECT
       [vri2_Ordinateur].[Name] AS [NetBios],
       [dca5_AeX AC Primary User].[User],
       [dca3_AeX AC TCPIP].[Default Gateway],
       [vri2_Ordinateur].[Guid] AS [_ItemGuid],
       [dca3_AeX AC TCPIP].[IP Address] AS [ip],
       [dca4_AeX AC Identification].[OS Name] AS [OS],
       [dca4_AeX AC Identification].[OS Version],
       [dca6_SW BIOS Element].[Manufacturer],
       [dca4_AeX AC Identification].[Hardware Serial Number] AS [N/Serie],
       [dca7_Manufacturer].[Model],
       [dca8_Master].[Region]
    FROM
       [vRM_Computer_Item] AS [vri2_Ordinateur]
          LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [dca3_AeX AC TCPIP]
             ON ([vri2_Ordinateur].[Guid] = [dca3_AeX AC TCPIP].[_ResourceGuid])
          LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
             ON ([vri2_Ordinateur].[Guid] = [dca4_AeX AC Identification].[_ResourceGuid])
          LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca5_AeX AC Primary User]
             ON ([vri2_Ordinateur].[Guid] = [dca5_AeX AC Primary User].[_ResourceGuid])
          LEFT OUTER JOIN [Inv_SW_BIOS_Element] AS [dca6_SW BIOS Element]
             ON ([vri2_Ordinateur].[Guid] = [dca6_SW BIOS Element].[_ResourceGuid])
          LEFT OUTER JOIN [Inv_Manufacturer] AS [dca7_Manufacturer]
             ON ([vri2_Ordinateur].[Guid] = [dca7_Manufacturer].[_ResourceGuid])
          LEFT OUTER JOIN [Inv_Master] AS [dca8_Master]
             ON ([vri2_Ordinateur].[Guid] = [dca8_Master].[_ResourceGuid])
    WHERE
       (
          ([vri2_Ordinateur].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
       )
     

    [dca7_Manufacturer].[Model] line doen't display any information I don't know how to display the right information in the report I have created

     



  • 4.  RE: Machine modele report

    Posted Apr 16, 2012 09:56 PM

    There are many ways to get model information.  I typically use vAsset:

    SELECT vc.[Name],va.[Model] FROM vComputer vc
    JOIN vAsset va ON va._ResourceGuid=vc.Guid

    vAsset is populated from Inv_Manufacturer, which is synchronized with Inv_HW_Logical_Device.  Inv_Manufacturer is also the table being used in your report. If the field is blank, the likely answer is that the computer(s) you are reporting on have not run the hardware inventory that populates the Inv_HW_Logical_Device table.  Have you run a delta or full hardware inventory on these computers that are showing blank data?



  • 5.  RE: Machine modele report

    Posted Apr 17, 2012 06:15 AM

    As I already said in may previous comment, the machines display hardware and software information on the reports. The only field which displays no information is [Manufacturer].[Model] via report builder. 

    Luke already gave me a solution to displays the information I need but I want to use report builder to have the same result and it seems that it is not possible.

    I will open a ticket on this point on the support.  



  • 6.  RE: Machine modele report

    Posted Apr 18, 2012 06:51 PM

    SELECT     vComputerEx.Name, va.Model, va.[Serial Number], va.Manufacturer, va.[Asset Type], va.Status, vComputerEx.Domain,
                          vComputerEx.[User], vComputerEx.[OS Name], vComputerEx.[OS Version], vComputerEx.[IP Address], vComputerEx.[OS Primary Language],
                          vComputerEx.[MAC Address], vComputerEx.[System Type], vComputerEx.Guid
    FROM         vAsset AS va INNER JOIN
                          vComputerEx ON va._ResourceGuid = vComputerEx.Guid
    WHERE     (va.[Asset Type] LIKE 'Computer') AND (vComputerEx.IsManaged LIKE 1)
    ORDER BY Name
     



  • 7.  RE: Machine modele report
    Best Answer

    Posted Apr 19, 2012 11:15 PM

    Sorry, I am thick-headed.

    Please review this KB:
    http://www.symantec.com/business/support/index?page=content&pmv=print&impressions=&viewlocale=&id=HOWTO7202

    Inv_Manufacturer is a CMDB solution data class that is populated by the 'Inventory to Asset Synchronization' task.  You must run this task to populate Inv_Manufacturer with data pulled from Inv_HW_Logical_Device (and some other tables).  Once this is done, you will see data in Inv_Manufacturer and can use [Manufacturer].[Model] from the Report Builder.

    Luke's workaround is successful because the vHWComputerSystem view does the work (within the view) to match the correct Model from Inv_HW_Logical_Device to the computer itself (as opposed to a DVD drive or component).  My workaround using vAsset is not successful because vAsset relies on Inv_Manufacturer.

    Does this help?



  • 8.  RE: Machine modele report

    Posted Apr 20, 2012 05:53 AM

    Thanks for your reply It is very helpful. Now [Manufacturer].[Model] from the Report Builder displays the information needed.

    The CMDB Solution task "Inventory to Asset Synchronization" (Manage > Jobs and Tasks > System Jobs and Tasks > Service and Asset Management > CMDB) works fine.

    It is not explained  in the kb why this task is not running automaticaly by default.

    For information I can not download the document attached present in the kb

     

     



  • 9.  RE: Machine modele report

    Posted Apr 22, 2012 01:37 AM

    Best regards



  • 10.  RE: Machine modele report