Label reporting
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?
I am a basic level SQL, can anyone help me?
1 Comment
[ + ] Show comment
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
Hobbsy
7 years ago
Top Answer
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
Comments:
-
Thank you! I will try this! - fabio.jourdan 7 years ago
HOSTNAME1 > Removed from LABEL2
HOSTNAME2 > Removed from LABEL7
HOSTNAME8 > Added to LABEL3 - fabio.jourdan 7 years ago