on all our computer is the inventory number set in the enviroment variable. The syntax for the inventory number is like "06/22222"
I try to create a report about sql but is still empty.
select Computers.Name as "Computer Name", Computers.Description, EnvironmentVariables.Value as "Inventarnummer" from Computers,EnvironmentVariables where computers.computerid = environmentvariables.computerid and EnvironmentVariables.Name like "Inventarnummer"
I think the Report has problem with the character "/".
I try also an other enviroments. This stilll works.
can you confirm this?
Kind Regards Martin
Please sign in to leave a comment.