Add Affected User to AAW Requests using Orchestrator Runbooks or PowerShell

As some of you may know, the requests generated in Service Manager through the Application Approval Workflow (AAW) Solution Accelerator do not set the Affected User in the Request.

I’ve recently implemented the solution for one of my customers and it was requested that users submitting these application requests be able to view them from the Service Manager Self-Service Portal (SSP).

However without the Affected User relationship being defined with the work item, the only place to view the application request status is by going to “My Requests” in the Application Catalog page from ConfigMgr. I was tasked with setting the “Created By” user as the “Affected User” so that when an application is requested, it will show up in their My Requests section of the SSP.

After some research, it was fairly difficult to find any in-depth documentation on how this may be performed. So, it was up to me to get it done.

Subsequently, I was able to create a PowerShell script, and an Orchestrator Runbook.

Below is a link to my SkyDrive for downloading the files. Please use and comment if there are any suggested modifications/ changes.

The script requires the SCSM PowerShell Cmdlets (SMLets). They can be found at http://smlets.codeplex.com

 

Download Files Here

SCSM 2012 Disk Requirements for DB Servers

Please keep in mind that this does not take precedence over the information provided in the MS Infrastucture Planning Guide.

Full documentation and planning guidance for System Center 2012 Service Manager can be found HERE.

Alternatively, the documentation may also be found in Microsoft’s TechNet Library.

The following calculations were derived from the ‘SM2012_Sizer.xlsm‘ (sizing calculator) contained within the SM_job_aids zip file from Microsoft. Though the calculations below may vary slightly from what is in the sizing calculator mentioned above, they should nonetheless be very close.

Please keep in mind that the default settings for data retention of 90 days in the Management DB and 1095 days in the Data Warehouse are the “Best Practice” recommendations from Microsoft. If we choose to set the retention for longer periods of time, we can mitigate performance issues within the console through the use of multiple work item views as well as adding CPU cores/ threads and memory to the server.

With that said, here is the math…

Service Manager DB Sizing

#of computer work items per month

(#of Computers in CMDB * #of new incidents per month) + #of new change requests

  • EXAMPLE:
    • 10,000 Computers * 3 new incidents per month = 30,000 new incidents per month
    • 30,000 + 500 new change requests = 30,500 computer work items per month

SvcMgr DB (GB)

1 + ((500 +( 5 * Work item retention days)) * #of computer work items per month) / 1,000,000

  • EXAMPLE:
    • 5 * 180 Work item data retention days = 900
    • 1 + 500 + 900 = 1,401
    • 1,401 * 30,500 = 42,730,500
    • 42,730,500 / 1,000,000 = 42.7305
    • SvcMgr DB = 43GB

Minimum total disk size (GB) for DB

SvcMgr DB *1.53

  • EXAMPLE:
    • 43GB * 1.53 = 65.79GB
    • Minimum Total Disk = 66GB

Data Warehouse Sizing

DWStagingandConfig

SvcMgr DB Size * 2

  • EXAMPLE:
    • 43GB * 2 = 86GB
    • DWStagingandConfig = 86GB

Repository

SvcMgr DB * (Data Retention Days/365) * 2

  • EXAMPLE:
    • 1095 Data Retention Days / 365 = 3
    • 43GB * 3 = 129GB
    • 129GB * 2 = 258GB
    • Repository = 258GB

DWDataMart

SvcMgr DB * (Data Retention Days/365) * 2

  • EXAMPLE:
    • 1095 Data Retention Days / 365 = 3
    • 43GB * 3 = 129GB
    • 129GB * 2 = 258GB
    • DWDataMart = 258GB

TempDB

SvcMgr DB * 5

  • EXAMPLE:
    • 43GB * 5 = 215GB
    • TempDB = 215GB

DWASDataBase

DWDataMart * 0.2

  • EXAMPLE:
    • 258GB * 0.2 = 51.6GB
    • DWDataMart = 52GB

Minimum total disk size (GB) for DW

(DWStagingandConfig + Repository + DWDataMart + TempDB + DWASDataBase) * 1.53

  • EXAMPLE:
    • 86GB + 258GB + 258GB +215GB + 52GB = 869GB
    • 869GB * 1.53 = 1,329.57GB
    • Minimum Total Disk = 1,330GB