Recent Updates 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

    ———-

     

     
  • SithaYuvaraj 7:46 am on July 4, 2012 Permalink | Reply  

    Application Catalog “Cannot Connect to Server” Error 

    Hi All,

    today i got in to a Application Catalog error and tried the WCF and .Net 4.0 installation and enabling trick. but still its not working.

    as a workaround i modified the SQL String in IIS. below is the steps to do that check if this resolves your issue.

    my SQL is running in Named Instance with different ports.

    .

    Note: Any Changes to Connection String will be overwritten to Default settings, post SCCM server restart.

    .

    1. open IIS -> Expand “Sites” -> Expand “Default Web Site” -> Just Click on “CMApplicationCatalogSvc”

    2. in the Features View -> Double Click “Connection String”

    3. Right Click on “Default” -> Click “Edit”

    4. Check the string and remove domain name

    Example :

    Before = Data Source=Server2.testlab.com\SCCMDB

    After = Data Source=Server2\SCCMDB

    5. Click OK and refresh the Application Catalog webpage and check if that works.

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

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

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

    Image

    Image

    Image

    Image

     
    • George 10:08 am on August 17, 2012 Permalink | Reply

      Thanks for this piece of information. now the only problem i have is once the machine is restarted the settings are changed back the application catalog fails again.

      any tips?

    • SithaYuvaraj 7:46 pm on August 17, 2012 Permalink | Reply

      Yes, you are correct. SCCM will overwrite the settings every time you reboot.
      you will get this issue only in lab environment, DNS is the culprit. in production i never had these issues.

    • Armaghan 10:35 pm on July 9, 2013 Permalink | Reply

      If you have IPV6 enabled on SCCM server you may run into this issue as well. Disabling it resolves this issue but problem is I’m not sure what else it can break like Direct Access etc.

  • SithaYuvaraj 5:45 am on July 3, 2012 Permalink | Reply  

    Device Collection Creator for SCCM 2012 

    Hi All,

    i like to share the Collection Creator Tool for SCCM 2012.

    Download the Tool from my Sky Drive: http://sdrv.ms/Rxq6pt

    Use the File with Care.

    Note: Use dot “.” in the server name box,  if you are running the tool in the SCCM Server.

    .

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

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

    • This posting is provided AS-IS with no warranties/guarantees and confers no rights.
    • .
     
    • Ramesh 3:51 pm on October 18, 2012 Permalink | Reply

      Yuvara- I tried copying it into a text file and save that as HTA. But i am getting script error “line 176” invalid charater!

      What am i doing wrong ?

      Thanks,
      Ramesh

    • Phil 2:01 pm on November 26, 2013 Permalink | Reply

      Tidy job, Thank you. This is just what I need whilst needing to create report collections before Migration.

  • 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