Name Change Report
Is there a way to build a report on workstations that have had their workstation name changed that will also display previous workstation names?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
dugullett
11 years ago
Using 5.4.
SELECT DISTINCT A.NAME, TIME, VALUE1 AS 'OLD NAME', VALUE2 AS 'NEW NAME' FROM ASSET_HISTORY A where CHANGE_TYPE = 'MODIFICATION' AND FIELD_NAME = 'NAME'
Comments:
-
I'm not on 5.4 yet. I guess that is why I'm getting the following error: mysql error: [1054: Unknown column 'A.NAME' in 'field list'] - andyclement 11 years ago
-
Yes that field doesn't exist until 5.4. There might be a better way to do it in 5.3, but I'll have to look. I know the reports like that get a lot easier in 5.4. - dugullett 11 years ago
-
Thank you. - andyclement 11 years ago
