Is it possible to generate a report which will show devices that were previously unmanaged and when but have come back on line?
Take a look at this report that I uploaded to the content sharing zone and see if it is close to what you are looking for.
There is a report available from the Content Sharing Zone -
Thanks but that was not what I was looking for. I am looking for a report that will show what nodes have been unmanaged previously. This report only shows the currently unmanaged devices. I am not even sure if it is possible.....
I looked around both 8.5 and 9.0 and it appears that both have an event type of 40 for unmanage and 41 for manage. You can modify any of the Event reports to use that as your criteria versus what the canned report has.
If you want to free style this you would use the events and eventstype tables.
Let me know if that helps.
If sedmo's report isn't what you are looking for, this query might give you a head start on building it as an Advanced SQL Report:
SELECT Caption, Status, Unmanaged, UnmanageFrom, UnmanageUntil FROM Nodes WHERE UnmanageUntil > 0 AND Unmanaged=0
The "UnmanageUntil>0" condition will filter to give you only nodes that have previously been unmanaged. Nodes that have never been unmanaged will still have UnmanageUntil=0, which is how they start out. The "Unamanged=0" condition will filter to give you only nodes that are not currently unmanaged.
semo, worked like a champ! Thanks for the report.
