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