Report Showing Computer Name Change
I am looking to create a report that would alert me of a change to a computers 'Computer Name' or as it is referred to in KACE 'Name'. Any suggestions would be greatly appreciated!
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
brucegoose03
8 years ago
Definitely could be done looking at Asset History. Let me see if i can whip something up
Comments:
-
Nice! Thanks! - samsquanch57 8 years ago
Posted by:
brucegoose03
8 years ago
Try something like this as MySQL report:
select concat(ASSET_HISTORY.VALUE1,' to ',ASSET_HISTORY.VALUE2) As 'Change Value', ASSET_HISTORY.NAME, ASSET_HISTORY.TIME from ASSET_HISTORY where
ASSET_HISTORY.NAME Like 'WIN7%' and
CHANGE_TYPE = 'Modification' and
FIELD_NAME = 'Name';
