I've scratched my head on this.
Can anyone think of a way to identify a machine as being a "Lancache" server in a view besides just creating a custom field and manually flagging it?
Put another way, I'd like to create a view which contains any machine that is a LanCache. I can't find any SQL variable which contains anything referencing LanCache.
Thanks for any ideas!
The lancache definitions are in systemFileShare table.
Thank you, Craig.
This isn't a "provided view" in Kaseya though. Can I create a variable directly from a table?
Unfortunately, views are limited and you can't base a view on SQL code as-is. You really need this mod: community.kaseya.com/.../98424.aspx which is very advanced stuff indeed, but will solve your issue.