Kaseya Community

Identify LanCache servers in a view

  • 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.