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 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

 

Additional Information

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