• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 15 subscribers
  • Views 283 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

How do I create a report that show any nodes been add/edit/remove

FormerMember
FormerMember

Hello everyone,

I am trying to create a report that show me any nodes been add/edit/remove within a 30 days period? I originally thought maybe event summary could help but it also show additional misc. I do not want showing up on my report.

Thanks

jbcreech

  • 0

    Try this:

    Select AuditingEvents.TimeLoggedUtc,Nodes.Caption,AuditingEvents.AccountID,AuditingActionTypes.ActionTypeDisplayName

    From AuditingEvents

    INNER Join AuditingActionTypes

    ON AuditingEvents.ActionTypeID = AuditingActionTypes.ActionTypeID

    INNER Join Nodes

    ON AuditingEvents.NetObjectID = Nodes.NodeID

    Where AuditingEvents.ActionTypeID BETWEEN '24' AND '29' AND

    AuditingEvents.TimeLoggedUtc>=DateAdd(d,-30, dateadd(d,0,datediff(d,0,getdate())))

    Order by AuditingEvents.TimeLoggedUtc DESC

  • FormerMember
    0 FormerMember in reply to ctlswadmin

    Thank you for the response. I will give this a try sometime soon.emoticons_happy.png

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.