http://www.systemcentercentral.com/tabid/60/indexId/60580/tag/Forums/Default.aspx

below sccm2007 report

select
 RS.Name0,
OS.Caption0,OS.CSDVersion0,PS.ID,PS.Qnumbers,Laststatename,AD_Site_Name0,

      LastStatusTime,ps.Title,WS.LastHWScan

      FROM dbo.v_R_System RS

      INNER JOIN dbo.v_GS_Workstation_Status WS ON RS.ResourceID = WS.ResourceID

      INNER JOIN dbo.v_GS_Operating_System OS ON RS.ResourceID = OS.ResourceID

      INNER JOIN dbo.vSMS_G_System_PatchstatusEx PS ON RS.ResourceID = PS.ResourceID

      INNER JOIN dbo.vsms_ApplicableUpdatesSummaryEx AUS ON AUS.UpdateID = PS.UpdateID

      inner join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = RS.ResourceID

      --inner join dbo.v_GS_OPERATING_SYSTEM OS on OS.ResourceID = RS.ResourceID

      Where

      client0 = 1 and active0 = 1 and obsolete0 = 0

      and PS.ID like 'MS%'

      and AUS.TimeAuthorized is not null

      --and Operating_System_Name_and0 not like '%server%'

      AND OS.Caption0 LIKE '%2008%'

      and Laststatename like 'reboot%'

      --and RS.Name0 like 'rcb-fps01' 

      and FCM.CollectionID LIKE 'SMS00001'

            --and (WS.LastHWScan > CURRENT_TIMESTAMP - 30)

      and (ps.LastStatusTime > CURRENT_TIMESTAMP -30)

      ORDER BY 4

I`m working on implementing SCCM 2012 and some of the other products.

My goal is to build a System Center environment that is able to do both monitoring, deployments and automatic deployments.  All systems are based on Microsoft technologies.

Our current environment is build up with 3 different forests, and has NO trust between them.

Forest A – has about 100 servers in the same domain.

Forest B – Has about 150 servers in the same domain.

Forest C – has about 1000 servers in the same domain.

Each forest has its own network with firewall. I will be able to make firewall openings, but not any AD trusts.

I have read the planning guides on TechNet, and it says that you cannot build a hierarchy without two-way trust. I also found that the same document says that you can have one site that spans over my 3 forests. This can be done by installing site system server in each forest.  Maybe this is the only way to do it?

I´m a bit unsure which design is the best for my setup so I would like some input / comments on how to build up my new System Center environment to support my current infrastructure without making big changes to it.

Thanks.
Tommy