Updates from October, 2012 Toggle Comment Threads | Keyboard Shortcuts

  • SithaYuvaraj 9:49 pm on October 16, 2012 Permalink | Reply
    Tags: SCCM 2012 Report   

    SCCM 2012 Report for All Active Content Replication with % Completed 

    Hi All,

    We had a requirement to create a report to include the Package transfer details in SCCM 2012 Report.

    In SCCM 2012, the logs are really magical and it captures more information then SCCM 2007

    When you Open All Active Content Replication report you will come to know how many packages are in Que

    But you need to open the status message or Package Transfer log to identify which package is actually getting transfered and how much has been completed.

    I have created a report which will include this information in the All Active Content Replication Report which will become handy in your day to day tasks.

    You can edit the Default report and click save as and copy paste the below code in the datasheet.

    Image

    Feel free to let me know if you have any difficulty in getting this report.

    SQL Query

    ———–

    select
    pkg.Name as C062,
    pkg.PackageID,
    SUBSTRING(dp.ServerNALPath, CHARINDEX(‘\\’, dp.ServerNALPath) + 2, CHARINDEX(‘”]’, dp.ServerNALPath) – CHARINDEX(‘\\’, dp.ServerNALPath) – 3 ) AS C070,
    dp.SiteCode,
    dp.LastRefreshTime,
    stat.SourceVersion,
    stat.LastCopied,
    stat.SummaryDate,
    (select top 1 msg.InsString3
    from v_StatMsgWithInsStrings msg
    join v_StatMsgModuleNames modNames on msg.ModuleName = modNames.ModuleName
    join v_StatMsgAttributes attpkg on msg.RecordID=attpkg.RecordID and msg.Time=attpkg.AttributeTime
    join v_StatMsgAttributes attdp on msg.RecordID=attdp.RecordID and msg.Time=attdp.AttributeTime
    where attpkg.AttributeValue =pkg.PackageID and msg.MessageID=’8204′
    and msg.InsString2 =SUBSTRING(dp.ServerNALPath, CHARINDEX(‘\\’, dp.ServerNALPath) + 2, CHARINDEX(‘”]’, dp.ServerNALPath) – CHARINDEX(‘\\’, dp.ServerNALPath) – 3 )
    order by msg.Time desc) as ‘% Completed’,
    stat.InstallStatus
    from v_Package pkg
    join v_DistributionPoint dp on pkg.PackageID=dp.PackageID
    join v_PackageStatusDistPointsSumm stat on dp.ServerNALPath=stat.ServerNALPath
    and dp.PackageID=stat.PackageID
    where stat.State!=0
    order by pkg.Name, dp.SiteCode

    ———-

     

    Advertisements
     
  • SithaYuvaraj 5:38 pm on April 6, 2012 Permalink | Reply  

    SCCM 2012 RTM Report to get All Site Server & System with there Roles 

    Hi All,

    I am going to share you the report i created for SCCM 2012 RTM to generate details about all site server and site system and there hostname and the roles they are running and there parent site code.

    and the short form for the roles used in this report are given below…

    SQL Server        –    SQL DB
    Distribution Point        –    DP
    Management Point        –    MP
    Device Management Point    –    DMP
    System Health Validator    –    SHV
    State Migration Point    –    SMP
    Provider            –    SMS Prov
    Software Update Point    –    SUP
    Fallback Status Point    –    FSP
    Multicast Service Point    –    MSP
    AMT Service Point        –    AMT
    AI Update Service Point    –    AI
    SRS Reporting Point        –    SRS
    Application Web Service    –    APP WS
    Portal Web Site        –    Por WS
    Enrollment Server        –    ES
    Enrollment Web Site    –    EWS
    Endpoint Protection Point    –    EPP

    —————–

    select distinct sys1.ServerName, sys5.Caption0 as ‘Operating System’,
    CASE sys4.SystemType0
    WHEN ‘x64-based PC’ THEN ‘x64’
    WHEN ‘x86-based PC’ THEN ‘x86’
    END as ‘Type’,
    sys2.SiteCode as ‘Site Code’, sys2.SiteName as ‘Site Name’, sys2.ReportingSiteCode as ‘Parent Site Code’,
    (select CASE sys3.RoleName
    WHEN ‘SMS SQL Server’ THEN ‘SQL DB’
    WHEN ‘SMS Component Server’ THEN NULL
    WHEN ‘SMS Distribution Point’ THEN ‘DP’
    WHEN ‘SMS Site Server’ THEN NULL
    WHEN ‘SMS Site System’ THEN NULL
    WHEN ‘SMS Management Point’ THEN ‘MP’
    WHEN ‘SMS Device Management Point’ THEN ‘DMP’
    WHEN ‘SMS System Health Validator’ THEN ‘SHV’
    WHEN ‘SMS State Migration Point’ THEN ‘SMP’
    WHEN ‘SMS Provider’ THEN ‘SMS Prov’
    WHEN ‘SMS Software Update Point’ THEN ‘SUP’
    WHEN ‘SMS Fallback Status Point’ THEN ‘FSP’
    WHEN ‘SMS Multicast Service Point’ THEN ‘MSP’
    WHEN ‘SMS AMT Service Point’ THEN ‘AMT’
    WHEN ‘AI Update Service Point’ THEN ‘AI’
    WHEN ‘SMS SRS Reporting Point’ THEN ‘SRS’
    WHEN ‘SMS Application Web Service’ THEN ‘APP WS’
    WHEN ‘SMS Portal Web Site’ THEN ‘Por WS’
    WHEN ‘SMS Enrollment Server’ THEN ‘ES’
    WHEN ‘SMS Enrollment Web Site’ THEN ‘EWS’
    WHEN ‘SMS Endpoint Protection Point’ THEN ‘EPP’
    END + ‘, ‘ as ‘data()’
    from v_systemresourcelist as sys3
    where (sys1.ServerName = sys3.ServerName) and ( NALPath not like ‘%SMSPXEIMAGES$%’)
    order by sys3.RoleName
    for xml path(”)) as ‘Site Roles’ from v_systemresourcelist as sys1
    left join v_site as sys2 on sys2.ServerName=sys1.ServerName
    left join v_gs_computer_system as sys4 on sys4.Name0=sys1.ServerName
    left join v_gs_operating_system as sys5 on sys5.resourceid=sys4.resourceid
    order by sys1.ServerName—————–

    • —————————————–

    Ur’s -> SithaYuvaraj | SCCM Administrator
    ——————————————

    • This posting is provided AS-IS with no warranties/guarantees and confers no rights.
 
  • SithaYuvaraj 2:57 pm on April 6, 2012 Permalink | Reply  

    SCCM Report to get All Site Server & System with there Roles 

    Hi All,

    This is my First Post in my WordPress Blog…

    I am going to share you the report i created and amazed my self with the outcome and i am sharing this report so that all SCCM Adminsitrators out there can make use of it.

    This report will give details about all site server and site system and there hostname and the roles they are running and there parent site code.

    and the short form for the roles used in this report are given below…

    AI Update Service Point    – AI
    AMT Service Point        – AMT
    Distribution Point        – DP
    Fallback Status Point    – FSP
    Management Point        – MP
    PXE Service Point        – PSP
    Reporting Point        – RP
    Server Locator Point    – SLP
    Software Update Point    – SUP
    SQL Server        – SQL DB
    SRS Reporting Point        – SRP
    State Migration Point    – SMP
    System Health Validator    – SHV

    Let me know if you have any query regarding this report.

    —————–

    select distinct sys1.ServerName, sys5.Caption0 as ‘Operating System’,
    CASE sys4.SystemType0
    WHEN ‘x64-based PC’ THEN ‘x64’
    WHEN ‘x86-based PC’ THEN ‘x86’
    END as ‘Type’,
    sys2.SiteCode as ‘Site Code’, sys2.SiteName as ‘Site Name’, sys2.ReportingSiteCode as ‘Parent Site Code’,
    (select CASE sys3.RoleName
    WHEN ‘SMS Site Server’ THEN NULL
    WHEN ‘SMS Component Server’ THEN NULL
    WHEN ‘AI Update Service Point’ THEN ‘AI’
    WHEN ‘SMS AMT Service Point’ THEN ‘AMT’
    WHEN ‘SMS Distribution Point’ THEN ‘DP’
    WHEN ‘SMS Fallback Status Point’ THEN ‘FSP’
    WHEN ‘SMS Management Point’ THEN ‘MP’
    WHEN ‘SMS PXE Service Point’ THEN ‘PSP’
    WHEN ‘SMS Reporting Point’ THEN ‘RP’
    WHEN ‘SMS Server Locator Point’ THEN ‘SLP’
    WHEN ‘SMS Software Update Point’ THEN ‘SUP’
    WHEN ‘SMS SQL Server’ THEN ‘SQL DB’
    WHEN ‘SMS SRS Reporting Point’ THEN ‘SRP’
    WHEN ‘SMS State Migration Point’ THEN ‘SMP’
    WHEN ‘SMS System Health Validator’ THEN ‘SHV’
    END + ‘, ‘ as ‘data()’
    from v_systemresourcelist as sys3
    where (sys1.ServerName = sys3.ServerName) and ( NALPath not like ‘%SMSPXEIMAGES$%’)
    order by sys3.RoleName
    for xml path(”)) as ‘Site Roles’ from v_systemresourcelist as sys1
    left join v_site as sys2 on sys2.ServerName=sys1.ServerName
    left join v_gs_computer_system as sys4 on sys4.Name0=sys1.ServerName
    left join v_gs_operating_system as sys5 on sys5.resourceid=sys4.resourceid
    order by sys1.ServerName

    —————–

    • —————————————–

    Ur’s -> SithaYuvaraj | SCCM Administrator
    ——————————————

    • This posting is provided AS-IS with no warranties/guarantees and confers no rights.

     
  • c
    Compose new post
    j
    Next post/Next comment
    k
    Previous post/Previous comment
    r
    Reply
    e
    Edit
    o
    Show/Hide comments
    t
    Go to top
    l
    Go to login
    h
    Show/Hide help
    shift + esc
    Cancel