PENDING sccm asset management apps or tool

[marwa ramadan]

hello everyone any one can help me i have SCCM system center configuration manager and service manager i need to make a system help me in asset management help me in add new devices and new users and can tell me number of machine by model do you know any microsoft app that can integrate to sccm or scsm and easily handle those mentioned things that can help desk uses ????

 

[Bob Hatcher]

hello everyone any one can help me i have SCCM system center configuration manager and service manager i need to make a system help me in asset management help me in add new devices and new users and can tell me number of machine by model do you know any microsoft app that can integrate to sccm or scsm and easily handle those mentioned things that can help desk uses ????

The simplest way is to use SQL.
Use CM_<Site Code>
SELECT GSCSP.Version0, Manufacturer0, Model0, Count(Model0) AS 'Count'
FROM dbo.v_GS_COMPUTER_SYSTEM as GSCP
inner join v_GS_COMPUTER_SYSTEM_PRODUCT as GSCSP on GSCSP.ResourceID = GSCP.ResourceId
GROUP BY Manufacturer0,Version0,Model0
ORDER BY Count Desc