/build/static/layout/Breadcrumb_cap_w.png
12/07/2016 1177 views
Hey guys!

Can we have a report that shows Label Modifications? I am trying many different ways with the "History" functionality... Here we have Device Smart labels created based on subnets, our departments and branches. And we need to monitor local desktop changes. I tried with "Connection e Disconnection" but this condition get any ip changes and dont give me the reality os subnet changes
I am a basic level SQL, can anyone help me?
Answer Summary:
1 Comment   [ + ] Show comment

Comments

  • To clarify are you trying to get a report that shows the labels for which a device is a member of and the history of changes of label membership?
    • Yeah, thats right. Like this, based in last week. Show only devices with changes

      HOSTNAME1 > Removed from LABEL2
      HOSTNAME2 > Removed from LABEL7
      HOSTNAME8 > Added to LABEL3

Answer Chosen by the Author

1
in short no, there is no easy way to show this, however you may be able to achieve something by copying machine label membership into your Asset records.

in the database MACHINE_LABEL_JT holds the machine ID and the label ID for which the machine is a member

If you need the name of the label you will find it in the LABEL table as LABEL.NAME and you will need to join t to the JT using the LABEL.ID field in both cases

By copying the membership information into an asset field using a scheduled ticket rule, you will at least see the history of the field so will be able to see when a machine changes membership.

But that is about as good as it gets from what I can see
Answered 12/08/2016 by: Hobbsy
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share