Reporting Group

 View Only

  • 1.  Need SQL Query

    Posted Oct 09, 2014 07:52 AM

    Need Query to list out all the replicated items with names in last n days.



  • 2.  RE: Need SQL Query

    Posted Oct 09, 2014 08:33 AM

    Does you need active altiris client list ?

    if yes see this Manny123 comments

    Need a Report for Active machine from last "N" days - Comment:18 Apr 2013 : Link

     

    I got the SQL Query
     
    SELECT     vc.Name, vc.Domain, vc.[OS Name], ictr.IsActive, ictr.LastRegistered, DATEDIFF(dd, ictr.LastRegistered, GETDATE()) AS Days, ihld.Manufacturer, ihld.Model,
                          ihld.[Device ID]
    FROM         dbo.vComputer AS vc LEFT OUTER JOIN
                          dbo.vHWComputerSystem AS ihld ON vc.Guid = ihld._ResourceGuid LEFT OUTER JOIN
                          dbo.Inv_Client_Task_Resources AS ictr ON vc.Guid = ictr._ResourceGuid
    WHERE     (ictr.IsActive = 1) AND (DATEDIFF(dd, ictr.LastRegistered, GETDATE()) < 60)
     
     


  • 3.  RE: Need SQL Query

    Posted Oct 09, 2014 08:58 AM

    Hi centhil,

        This query contains only the list of computers which are not active for the past 60 days. And also u have mentioned that u need the  replicated items with names for the past n days.

    Can you explain what exactly you are mentioning abou the replicated items.



  • 4.  RE: Need SQL Query

    Posted Oct 10, 2014 05:44 AM

    Created policy in Central NS and replicated down the hierarchy, Policies are received by gropy of clients from NS in particular site. But still application is not installed.

    So i need to check the replicated information from Central to down the heirarchy



  • 5.  RE: Need SQL Query

    Posted Oct 10, 2014 08:59 AM

    Chenthil,

    Couldn't you just sign into the Child NS directly and look at the policy there to see if everything looks right? I would probably start by checking that the associated packages are replicated down to your Child NS and\or package servers.

    You can also look at the reports in Reports > Notification Server Management > Server > Hierarchy for alerts and lists of the objects marked for replication. In some of those Reports, if you right click on the Replication Jobs you can drill down for more details.



  • 6.  RE: Need SQL Query
    Best Answer

    Posted Oct 10, 2014 11:13 AM

    Hi Centhil,

    To check the no replication policies are currently runnning

     Reports > Notification Server Management > Server > Current Replication Activity report 

    It will show the list of replication policies which are currently running.