SystemCenter Titans

Start-Transcript -Path c:transcript0.txt -noclobber # This scripts needs unrestricted access Write-Host "This scripts needs unrestricted access (Set-ExecutionPolicy Unrestricted.)" -ForegroundColor Green Write-Host "The prereq setup for System Center 2012 R2 Operations Manager takes around 15 minutes depending on your internet speed" -ForegroundColor Green # Setting the variables. $folderpath0 = 'C:Source' $ShareName = "Source$" #Check if folder exists, if not, create it if (Test-Path $folderpath0){ Write-Host "The folder $folderPath0 exists." } else{ Write-Host "The folder $folderPath0 does not exist, creating..." -NoNewline New-Item $folderpath0 -type directory | Out-Null Write-Host "done!" -ForegroundColor Green } # Check if file exists, if not, download it $file0 = $folderPath0+"SQLSysClrTypes.msi" $file1 = $folderPath0+"Reportviewer.msi" if (Te

SELECT     R.AD_Site_Name0,     Count(SMS_Installed_Sites0) AS 'Count' From     v_R_System R     JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID Group By     R.AD_Site_Name0 

select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX('\\', sys2.ServerNALPath) + 2, CHARINDEX('"]', sys2.ServerNALPath) - CHARINDEX('\\', sys2.ServerNALPath) - 3 ) + CASE sys2.Flags WHEN '1' Then ' (Slow)' WHEN '0' THEN '' END + '; ' as 'data()' from vSMS_BoundaryGroupSiteSystems as sys2 where sys1.GroupID=sys2.GroupID for XML path('')) as 'Site System', (select sys4.Value + '; ' as 'data()' from vSMS_BoundaryGroupMembers as sys3 left join vSMS_Boundary as sys4 on sys3.BoundaryID=sys4.BoundaryID where sys1.GroupID=sys3.GroupID for XML path('')) as 'Boundary', sys1.ModifiedOn, sys1.ModifiedBy from vSMS_BoundaryGroup as sys1

select sys.Name0 as 'Computer Name', sys.User_Name0 as 'User Name', summ.ClientStateDescription, case when summ.ClientActiveStatus = 0 then 'Inactive' when summ.ClientActiveStatus = 1 then 'Active' end as 'ClientActiveStatus', summ.LastActiveTime, case when summ.IsActiveDDR = 0 then 'Inactive' when summ.IsActiveDDR = 1 then 'Active' end as 'IsActiveDDR', case when summ.IsActiveHW = 0 then 'Inactive' when summ.IsActiveHW = 1 then 'Active' end as 'IsActiveHW', case when summ.IsActiveSW = 0 then 'Inactive' when summ.IsActiveSW = 1 then 'Active' end as 'IsActiveSW', case when summ.ISActivePolicyRequest = 0 then 'Inactive' when summ.ISActivePolicyRequest = 1 then 'Active' end as 'ISActivePolicyRequest', case when summ.IsActiveStatusMessages = 0 then 'Inactive' when summ.IsActiveStatusMessages = 1 the