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

Comments

Please log in to comment

Answers

0

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'
Answered 02/12/2013 by: dugullett
Red Belt

  • 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']
    • 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.
  • Thank you.
Please log in to comment
This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity