SQL Query to list products from SCCM Database

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

select *
FROM v_r_system as vrs
join v_GS_INSTALLED_SOFTWARE as VIS on VIS.resourceid = vrs.resourceid
where
Name0 LIKE ‘%Server Name%’

A full list of the Tables is : https://technet.microsoft.com/en-us/library/dd334659.aspx

 

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

SCOM Query Disk Space for 1 Day

select
vManagedEntity.Path
,Perf.vPerfdaily.DateTime
,Perf.vPerfdaily.SampleCount
,vPerformanceRule.ObjectName
,vPerformanceRule.CounterName
,vManagedEntity.Name
,Perf.vPerfdaily.Averagevalue
,Perf.vPerfdaily.MinValue
,Perf.vPerfdaily.MaxValue
,vRule.RuleDefaultName

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

Order by Path,Name

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

How to enable Log for an Microsoft Windows Log

In case tat you need to Enable the Log for an Microsoft Windows Log for example the Operational Log for Print Service you can do it from the MMC.

Enable Log

Other 2 options are:

– Command line:  wevtutil sl Microsoft-Windows-PrintService/Operational /e:true /q

– Change registry Key:  [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WINEVT\Channels\Microsoft-Windows-PrintService/Operational]
“Enabled”=dword:00000001

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Clean Ghost Orphaned entries in SCOM console

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

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Updates SCOM CU6 and SC UR1

System Center 2012 Products have been just released and we have an update.
System Center Update Rollup 1 that has updates for more products,
Virtual Machine Manager Server Update (KB2663959)
Virtual Machine Manager Console Update (KB2663960)
Virtual Machine Manager Self-Service Portal Update (KB2663961)
App Controller Update (KB2677596)
Operations Manager Update (KB2674695) – Windows monitoring
Operations Manager Update (KB2674695) – New feature
Description of Update Rollup 1 for System Center 2012

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.

Good luck with the updates!

VN:F [1.9.20_1166]
Rating: 8.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

System Center 2012 SP1 – Virtual Machine Manager

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)

From here you can download the Step-by-Step Guide for System Center 2012 SP1 – Virtual Machine Manager
A Interesting article can be found on the Technet website.

VN:F [1.9.20_1166]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Free Private Ccloud Beta Exam 071-246 and 071-247

In case that you want go get certificated on Microsoft Privat Cloud you can take the exams 071-246 and 071-247 free of charge during the Beta Period. For this you can use the Promotion Codes for Beta.

FREE PRIVATE CLOUD BETA EXAMS – ONLINE REGISTRATION NOW LIVE!
71-246 | Private Cloud Monitoring and Operations with System Center 2012
71-247 | Private Cloud Configuration and Deployment with System Center 2012

Use Promo Code:
PC46 for 071-246
PC47 for 071-247

Good, luck

VN:F [1.9.20_1166]
Rating: 7.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

System Center Operations Manager 2012

System Center Operation Manager 2012 is out!

System Center 2012 – Operations Manager (x86 and x64) – DVD (English)
Release Date: 4/2/2012

This is a picture from my TechNet Subscription.. so… if you have subscription.. you can download it!

There are also documents  that you can acces at this LINK

But guess what.. there are more System Center 2012 products released 

System Center 2012 – Unified Installer (x86 and x64) – DVD (English)
ISO|English|Release Date: 4/2/2012|Details
System Center 2012 – Orchestrator (x86) – DVD (English)
ISO|English|Release Date: 4/2/2012|Details
System Center 2012 – Service Manager (x64) – DVD (English, Chinese – Simplified, French, German, Italian, Japanese, Portuguese-Brazil, Russian, Spanish)
ISO|Multiple Languages|Release Date: 4/2/2012|Details
System Center 2012 – App Controller (x64) – DVD (English, Chinese – Simplified, French, German, Italian, Japanese, Portuguese-Brazil, Russian, Spanish)
ISO|Multiple Languages|Release Date: 4/2/2012|Details
System Center 2012 – Virtual Machine Manager (x64) – DVD (English, Chinese – Simplified, French, German, Italian, Japanese, Portuguese-Brazil, Russian, Spanish)
ISO|Multiple Languages|Release Date: 4/2/2012|Details
System Center 2012 – Data Protection Manager (x64) – DVD (English, Chinese – Simplified, French, German, Italian, Japanese, Portuguese-Brazil, Russian, Spanish)
ISO|Multiple Languages|Release Date: 4/2/2012|Details
System Center 2012 Configuration Manager and Endpoint Protection (x86 and x64) – DVD (English, Chinese – Simplified, French, German, Japanese, Russian)
ISO|Multiple Languages|Release Date: 4/2/2012|Details
System Center 2012 – Operations Manager (x86 and x64) – DVD (English)
ISO|English|Release Date: 4/2/2012|Details

VN:F [1.9.20_1166]
Rating: 8.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Course: “Creating and Managing a Private Cloud with System Center 2012 Jump Start”

Do you want to take part to a free charge Microsoft Training regarding System Center 2012?

Course: “Creating and Managing a Private Cloud with System Center 2012 Jump Start”
Date/Time: February 21-22, 2012 from 9:00am – 5:00pm PST
Where: Live virtual classroom (online from wherever you are)
Cost: FREE!
Target audience: IT Professionals (IT Implementers, managers, decision makers)
Register: HERE

Day 1: Deployment & Configuration

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

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Transforming IT with Microsoft Private Cloud

Transforming IT with Microsoft Private Cloud  – Live presetation

Starts: Tuesday, January 17, 2012 8:30 AM Time zone: (GMT-08:00) Pacific Time (US & Canada)
Duration: 2 hour(s)

You can register at https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032500061&Culture=en-US

Could be that Microsoft announces the release to manufacturing of System Center 2012 family!

 

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)