check for files.

[d_i_saunders]

is there an easy way to check if a file is present on a users desktop?
I have added this to the 'scanned files' section.

But for the report I don't know what to put. I just need to know the icon is there or not,,

Thanks

[Hemoco]

This thread might help you:

http://forum.lansweeper.com/yaf_postst611_Adobe-Reader-9-Help.aspx

[d_i_saunders]

ok. that might work...
Whats the SQL i need to check for the existance of a file ?

thnaks

[Hemoco]

It would not be possible for the server to know where %userprofile% belongs to.
Multiple users can be logged on to the system and multiple userprofiles will exist on the system when more than one user logs on.

Maybe a solution would be to place the icon in the "All users" folder?

[d_i_saunders]

the file i have asked it to scan is

%userprofile\desktop\myicon.lnk

Im assuming i need to use the if exsisits but not sure where to go after that..

I would like to be able to include this on the software reports, simply showing how many people have this icon on the deskotp

[Hemoco]

Could you post the path of the file you want to find, I'll try to create a sample query