|
|
 Rank: Premium user Groups: Member
, Premium Users
Joined: 8/7/2008 Posts: 42 Location: UK
|
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
|
|
 Rank: Administration Groups: Administration
Joined: 2/10/2005 Posts: 1,451 Location: Hamme Belgium
|
Could you post the path of the file you want to find, I'll try to create a sample query
|
|
 Rank: Premium user Groups: Member
, Premium Users
Joined: 8/7/2008 Posts: 42 Location: UK
|
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
|
|
 Rank: Administration Groups: Administration
Joined: 2/10/2005 Posts: 1,451 Location: Hamme Belgium
|
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?
|
|
 Rank: Premium user Groups: Member
, Premium Users
Joined: 8/7/2008 Posts: 42 Location: UK
|
ok. that might work... Whats the SQL i need to check for the existance of a file ?
thnaks
|
|
 Rank: Administration Groups: Administration
Joined: 2/10/2005 Posts: 1,451 Location: Hamme Belgium
|
|
|
|
Guest |