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