Resource Manager Home Page Queries

Products

• IT Management Suite
• Server Management Suite

Issue/Introduction

What are the queries used to populate the Resource Manager Home Page?

Environment

ITMS 7.x, 8.x

Resolution

 

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

 

Additional Information

180424 "How to give access to the Resource Manager menus"