Jump to content

Search the Community

Showing results for tags 'server service plan'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • MSPGeek
    • The Geek Cast
    • Code of Conduct
  • ConnectWise Automate / Labtech
    • ConnectWise Automate / LabTech
    • ConnectWise Automate / LabTech - Development

Categories

  • ConnectWise Automate
    • Scripts
    • Plugins
    • SQL Snippets
    • Role Definitions
    • Automate PowerShell Code
    • Reports
    • Internal Monitors
    • Remote Monitors
  • ConnectWise Manage
    • API Interacting Code

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Location


Agent Count


INTERESTS


OCCUPATION


ICQ


WEBSITE


WLM


YAHOO


AOL


FACEBOOK


GOOGLEPLUS


SKYPE


TWITTER


YOUTUBE

Found 1 result

  1. Here is a quick way to find the Service plans and the patching for workstations/servers for each location in a SQL format. SQL: SELECT clients.name AS ClientName, clients.clientid AS ClientID, locations.name AS LocationName, locations.locationid AS LocationID, v_extradatalocations.name AS EDFLocationName, v_extradatalocations.locationid AS EDFLocationID, `v_extradatalocations`.`Workstation Service Plan` AS `Workstation Service Plan`, `v_extradatalocations`.`Server Service Plan` AS `Server Service Plan`, `v_extradatalocations`.`Enable Patching Workstations` AS `Enable Patching Workstations`, `v_extradatalocations`.`Enable Patching Servers` AS `Enable Patching Servers` FROM v_extradatalocations LEFT JOIN locations ON v_extradatalocations.locationid = locations.locationid LEFT JOIN clients ON locations.clientid = clients.clientid Example Export:
×
×
  • Create New...