What are the queries used to populate the Resource Manager Home Page?
ITMS 7.x, 8.x
We will use a computer called "CL-####" with GUID = '########-b6a9-4795-8de4-177f025b0442' as an example. All this information can be collected by using Altiris Profiler and profiling when this page is loading.
1. General section:
EXECUTE spGetBasicPageGeneralInfo1 @resourceGuid='########-b6a9-4795-8de4-177f025b0442'
EXECUTE spGetBasicPageDates @resourceGuid='########-b6a9-4795-8de4-177f025b0442', @culture=N'en-US'
2. Identification section:
EXECUTE spGetFullPageIdentificationSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442'
3. Symantec Management Agent Details section:
EXECUTE spGetAltirisAgentDetailsSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442', @serverTime=0
4. Hardware Section:
EXECUTE spGetFullPageHardwareSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442'
5. Network section:
EXECUTE spGetBasicPageNetworkSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442'
6. Drives section:
EXECUTE spGetFullPageDrivesSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442'
7. Memory Modules section:
DECLARE @totalMemory__auto AS bigint;
EXECUTE spGetFullPageMemoryModulesSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442', @culture=N'en-US', @totalMemory=@totalMemory__auto OUTPUT
8. Microsoft Hotfixes section:
EXECUTE spGetFullPageMicrosoftHotfixesSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442'
9. Licensed Programs section:
EXECUTE spGetFullPageLicencedProgramsSection @resourceGuid='########-b6a9-4795-8de4-177f025b0442', @installedOnly=1
180424 "How to give access to the Resource Manager menus"