To list products that are installed on a Server using SQL Query to SSCM database you can use the Table v_GS_SoftwareProduct. This table contains “Lists the products found on each Configuration Manager client.”

from Perf.vPerfDaily
join vPerformanceRuleInstance on vPerformanceRuleInstance.PerformanceRuleInstanceRowid=Perf.vPerfDaily.PerformanceRuleInstanceRowid

join vPerformanceRule on vPerformanceRule.RuleRowId=vPerformanceRuleInstance.RuleRowId
join vManagedEntity on vManagedEntity.ManagedEntityRowid=Perf.vPerfDaily.ManagedEntityRowId
join vRule on vRule.RuleRowId=vPerformanceRuleInstance.RuleRowId
where Perf.vPerfDaily.Datetime between ‘2015-02-01’ and ‘2015-02-02′
and vPerformanceRule.ObjectName=’LogicalDisk’
and vPerformanceRule.CounterName=’Free Megabytes’
and vRule.RuleDefaultName LIKE ‘%Logical Disk Free Megabytes%’

In case that you have Server or Objects that do not report correctly in SCOM you can check the SQL table BaseManagedEntity.

You can check same table in case you want to delete Agents from the database directly or to the agents that somhow got Stuck ( they are not in Pending any longer but they are detected like Windows Computers in the state Not Monitored).

To do this

1) Check the values of the column IsDeleted from the table BaseManagedEntity by using the Query:

select * from BaseManagedEntity where FullName like ‘%FQDN of your computer%’

2) Set the value IsDeleted for the objects to 1.

UPDATE dbo.[BaseManagedEntity] SET IsDeleted = 1 where FullName like ‘%FQDN of your computer%’

The update is small compared with the previous MS updates for SCOM, the Download is 74MB in size.

In case that you still have the SCOM 2007 R2 Version, Microsoft released a new update Cumulatiove Update 6 that resolves some problems and adds new agents for IBM AIX 7.1 and Oracle Solaris 11
The update is still big but in the acceptabe size, 1 GB. You can get it from here.

In March there was published an article with the CTP Features of System Center Service Pack 1 for Virtual Machine Manager

Some of the interesting features are:
1)Add a Virtual Hard Disk Larger Than 2 TB to a Virtual Machine
2)Migrate a Running Virtual Machine Without Downtime using Live migrate:
-Live migrate the VM within a cluster
-Live migrate the VM in and out of a cluster
-Live migrate the storage of the VM from one storage sub-system to the other
-Live migrate the VM from one host to the other (with no shared storage)

Part 1: Understanding the Microsoft Private Cloud
Part 2: Deploying the Infrastructure Components
Part 3: Deploying the Private Cloud Infrastructure
Part 4: Deploying the Service Layer
Part 5: Deploying the Applications & VMs

Day 2: Management & Operations

Part 6: Managing the Infrastructure Components
Part 7: Managing the Private Cloud Infrastructure
Part 8: Managing the Service Layer
Part 9: Managing the Applications & VMs