Quick StartThe ReportMagic MenuReport StudioFilesSchedulesBatch JobsReport JobsDashboardsProfileAdminAccount DetailsGetting StartedAbout ReportMagicRegistering and Logging InReport LibrarySearching ReportMagicConnections and AgentsWriting ReportsStarting Out With Report StudioCreating Report TemplatesRMScriptMacro ShorthandReporting on Different Periods of TimeSetting Macro Parameter DefaultsStoring Input and Output FilesReport VariablesUsing Variable ParametersSpecifying How Graphs LookStep-by-Step LogicMonitor Graph ExamplesStep-by-Step Jira Graph ExamplesSpecifying How Tables LookChanging Fonts and ColorsUsing Macros in PowerPoint TemplatesRestricted MacrosGenerating Reports Using SchedulesUsing HTML Forms in SchedulesSeeing How Reports RanViewing ReportsCached ValuesUsing AggregationsAdvanced Report StudioAdvanced [Object.Graph:] MacroAPI AccessREST APIREST API - FilesAdvancedRole-Based Access Control (RBAC)SecurityMiscellaneousBadgesCertificationsTips, Tricks and Shortcut KeysMacrosAgentAgent.ConnectionAgent.ExecuteAgent.MonitorMagicNodeListAgent.MonitorMagicNodeMeasurementListAgent.MonitorMagicNodeMeasurementSummaryAgent.MonitorMagicNodePropertyListAgent.MonitorMagicNodeTypeListAgent.PropertyAgent.SqlAnalysisAgent.SqlGraphAgent.SqlListAgent.SqlTableAgent.SqlValueAgent.SqlValuesAgent.WebQueryAlertMagicAlertMagic.MetricsGraphAlertMagic.MetricsListAlertMagic.StatisticsAutoTaskAutoTask.AccountListAutoTask.AccountPropertyAutoTask.ConnectionAutoTask.CountAutoTask.FieldListAutoTask.FieldPropertyAutoTask.ListAutoTask.PropertyAutoTask.SummaryValueAutoTask.TicketListAutoTask.TicketPropertyAzureAzure.ConnectionAzure.LogAnalyticsGraphAzure.LogAnalyticsQueryAzure.LogAnalyticsScalarAzure.LogAnalyticsTableAzure.ResourceGroupListAzure.ResourceListAzure.ResourcePropertiesAzure.SentinelAlertRuleListAzure.SentinelConnectorListAzure.SentinelIncidentListAzure.SentinelThreatIndicatorListAzure.SentinelThreatIndicatorMetricListAzure.SubscriptionListBloggerBlogger.BlogPropertyBlogger.ConnectionBlogger.PageBlogger.PageListBlogger.PagePropertyBlogger.PostBlogger.PostListBlogger.PostPropertyCacheCache.ExpiresCache.GetCache.IsSetCache.SetCache.UnsetCertifyCertify.ConnectionCertify.DepartmentListCertify.DepartmentPropertyCherwellCherwell.BusinessObjectDefinitionListCherwell.BusinessObjectListCherwell.BusinessObjectSchemaCherwell.BusinessObjectSummaryCherwell.ConnectionCiscoCisco.ConnectionCisco.FirmwareVersionPropertyCisco.SecurityAdvisoryListCisco.SerialNumberPropertyCisco.SoftwareSuggestionListCiscoDnaCenterCiscoDnaCenter.ConnectionCiscoDnaCenter.SiteListCiscoDnaCenter.SitePropertyCloudHealthCloudHealth.AssetDetailsCloudHealth.AssetListCloudHealth.AvailableReportDimensionsCloudHealth.AvailableReportOptionsCloudHealth.AvailableReportsListCloudHealth.AwsAccountDetailsCloudHealth.AwsAccountsListCloudHealth.ConnectionCloudHealth.CustomerDetailsCloudHealth.CustomerListCloudHealth.CustomerReportDetailsCloudHealth.CustomerStatementDetailsCloudHealth.OrganisationAccountsListCloudHealth.OrganisationListCloudHealth.QueryCodacyCodacy.ConnectionCodacy.ListConnectWiseManageConnectWiseManage.ConnectionConnectWiseManage.CountConnectWiseManage.DictionaryConnectWiseManage.ListConnectWiseManage.PropertyCoreArrayArray.CountBreakBreakpointCalculateColorCommentContinueConvertDeleteDeleteRowDocumentBookmarkDocumentBreakDocumentInsertSectionDocumentSectionEmailEmailFileEmailReportExecuteForEachFormatTableCellFormatTableRowIfIgnoreIncInsertTableCellImageIsSetLinearRegressionLinkMapObjectRandomRegexRepeatRowSearchAndReplaceSectionSettingsSleepStopStopwatchStringStringIndexSubstringSwitchThrowExceptionUnsetWarningWhileDatabaseDatabase.ConnectionDatabase.GraphDatabase.ListDatabase.TableDatabase.ValueDatabase.ValuesDataMagicDataMagic.SyncDictionaryDictionary.ItemDictionary.KeysDictionary.ValuesDocumentDocument.SetPropertiesDropBoxSignDropBoxSign.ConnectionFileFile.CopyFile.CopyOutputFilesFile.Csv.CellFile.Csv.RowFile.Csv.RowCountFile.Csv.TableFile.EmbedFile.ExecuteFile.ExistsFile.ImageFile.InsertFile.ListFile.LoadListFile.LoadObjectFile.LoadStringFile.LoadVariablesFile.SaveObjectFile.Xlsx.CellFile.Xlsx.RowFile.Xlsx.RowCountFile.Xlsx.TableFunctionFunction.CallFunction.DefineGoogleGoogle.ConnectionGoogle.TableGraphGraph.AddDataGraph.DeleteDataGraph.RenameDataGraph.UpdateGravatarGravatar.ImageHaloPsaHaloPsa.ConnectionHaloPsa.ListHighlightHighlight.BearerSummaryHighlight.BroadbandSummaryHighlight.CellularSummaryHighlight.ConnectionHighlight.FolderListHighlight.HttpServerPerformanceSummaryHighlight.IcmpTcpUdpPerformanceSummaryHighlight.MosPerformanceSummaryHighlight.PrecisionPerformanceSummaryHighlight.TunnelSummaryHighlight.WatchNodeListHighlight.WirelessAccessPointSummaryHubSpotHubSpot.ListHubSpot.PropertyHubSpot.QueryJarrayJarray.TableJiraJira.AttachmentImageJira.AttachmentListJira.AttachmentPropertyJira.ConnectionJira.GraphJira.InsertMarkupJira.IssueAnalysisJira.IssueCommentListJira.IssueCommentPropertyJira.IssueLastCommentPropertyJira.IssueListJira.IssuePropertyJira.IssueResponseTimeJira.LastImageJira.StatusListJira.TableJira.TimeInStateJira.UserListJira.UserPropertyJsonJson.ItemJson.ListKrokiKroki.ImageListList.AddList.AnalysisList.ComplementList.CountList.DequeueList.DuplicatesList.FirstList.GraphList.GroupByList.IndicesOfList.IntersectionList.ItemList.RangeList.SelectList.SelectColumnsList.SortList.SummaryValueList.TableList.UnionList.WhereLogicMonitorLogicMonitor.AccountPropertyLogicMonitor.AlertAnalysisLogicMonitor.AlertCalendarLogicMonitor.AlertCountLogicMonitor.AlertListLogicMonitor.AlertMapLogicMonitor.AlertPropertyLogicMonitor.AlertRuleListLogicMonitor.AlertRulePropertyLogicMonitor.AlertStatusLogicMonitor.AlertTableLogicMonitor.AppliesToFunctionListLogicMonitor.AppliesToFunctionPropertyLogicMonitor.AppliesToListLogicMonitor.AuditEventAnalysisLogicMonitor.BigNumberWidgetValuesLogicMonitor.ClearCacheLogicMonitor.CollectorExecuteLogicMonitor.CollectorGroupListLogicMonitor.CollectorGroupPropertyLogicMonitor.CollectorListLogicMonitor.CollectorPropertyLogicMonitor.CollectorVersionListLogicMonitor.CollectorVersionPropertyLogicMonitor.ConfigCheckListLogicMonitor.ConfigCheckPropertyLogicMonitor.ConfigSourceGroupListLogicMonitor.ConfigSourceListLogicMonitor.ConfigSourcePropertyLogicMonitor.ConfigSourceXmlLogicMonitor.ConnectionLogicMonitor.ConnectionApiTokenLogicMonitor.ConvertToLiveWidgetLogicMonitor.DashboardLogicMonitor.DashboardGroupListLogicMonitor.DashboardGroupPropertyLogicMonitor.DashboardListLogicMonitor.DashboardPropertyLogicMonitor.DashboardWidgetListLogicMonitor.DatamartSyncLogicMonitor.DataPointListLogicMonitor.DataPointPropertyLogicMonitor.DataSourceGraphListLogicMonitor.DataSourceGraphPropertyLogicMonitor.DataSourceGroupListLogicMonitor.DataSourceListLogicMonitor.DataSourcePropertyLogicMonitor.DataSourceXmlLogicMonitor.DeviceConfigSourceFileLogicMonitor.DeviceConfigSourceInstanceListLogicMonitor.DeviceConfigSourceListLogicMonitor.DeviceConfigSourcePropertyLogicMonitor.DeviceCountLogicMonitor.DeviceDataSourceListLogicMonitor.DeviceDataSourcePropertyLogicMonitor.DeviceGroupListLogicMonitor.DeviceGroupPropertyLogicMonitor.DeviceListLogicMonitor.DevicePropertyLogicMonitor.DeviceSlaWidgetPropertyLogicMonitor.DeviceTableLogicMonitor.EscalationChainDestinationListLogicMonitor.EscalationChainDestinationPropertyLogicMonitor.EscalationChainListLogicMonitor.EscalationChainPropertyLogicMonitor.EventSourceFilterListLogicMonitor.EventSourceFilterPropertyLogicMonitor.EventSourceGroupListLogicMonitor.EventSourceListLogicMonitor.EventSourcePropertyLogicMonitor.EventSourceXmlLogicMonitor.FinancialInformationLogicMonitor.ForecastLogicMonitor.GraphLogicMonitor.GraphSpecificationLogicMonitor.HistoricSdtListLogicMonitor.ImageLogicMonitor.InstanceAnalysisLogicMonitor.InstanceCountLogicMonitor.InstanceDetailsTableLogicMonitor.InstanceGroupCountLogicMonitor.InstanceGroupListLogicMonitor.InstanceListLogicMonitor.InstancePropertyLogicMonitor.IntegrationListLogicMonitor.IntegrationPropertyLogicMonitor.JobMonitorListLogicMonitor.JobMonitorPropertyLogicMonitor.LastMeasurementLogicMonitor.LogAnalysisLogicMonitor.LogicModuleMetadataPropertyLogicMonitor.LogicModuleUpdateListLogicMonitor.LogicModuleUpdatePropertyLogicMonitor.LogItemListLogicMonitor.NetscanGroupListLogicMonitor.NetscanGroupPropertyLogicMonitor.NetscanListLogicMonitor.NetscanPropertyLogicMonitor.NewUserMessagePropertyLogicMonitor.PaymentInformationLogicMonitor.PercentageAvailabilityLogicMonitor.PortalVersionLogicMonitor.PropertySourceGroupListLogicMonitor.PropertySourceJsonLogicMonitor.PropertySourceListLogicMonitor.PropertySourcePropertyLogicMonitor.QueryLogicMonitor.RecipientGroupListLogicMonitor.RecipientGroupPropertyLogicMonitor.RecycleBinItemListLogicMonitor.RecycleBinItemPropertyLogicMonitor.ReportGroupListLogicMonitor.ReportGroupPropertyLogicMonitor.ReportListLogicMonitor.ReportPropertyLogicMonitor.ResourceAnalysisLogicMonitor.ResourceGroupAnalysisLogicMonitor.RoleListLogicMonitor.RolePropertyLogicMonitor.SdtListLogicMonitor.SdtPercentageLogicMonitor.SdtPropertyLogicMonitor.SingleSignOnPropertyLogicMonitor.SlaWidgetValuesLogicMonitor.SnmpSysOidMapListLogicMonitor.SnmpSysOidMapPropertyLogicMonitor.SummaryValueLogicMonitor.SummaryValueListLogicMonitor.ThresholdLogicMonitor.TrafficTableLogicMonitor.UnmonitoredDeviceListLogicMonitor.UnmonitoredDevicePropertyLogicMonitor.UserApiTokenListLogicMonitor.UserApiTokenPropertyLogicMonitor.UserListLogicMonitor.UserPropertyLogicMonitor.WebsiteCheckpointDataListLogicMonitor.WebsiteCountLogicMonitor.WebsiteGroupAnalysisLogicMonitor.WebsiteGroupCountLogicMonitor.WebsiteGroupListLogicMonitor.WebsiteGroupPropertyLogicMonitor.WebsiteListLogicMonitor.WebsitePropertyLogicMonitor.WidgetStatusMagicSuiteMagicSuite.ApplyBrandMagicSuite.BadgeListMagicSuite.ConnectionMagicSuite.ConnectionListMagicSuite.ConnectionPropertyMagicSuite.ConnectionStatusPropertyMagicSuite.FeedbackListMagicSuite.FeedbackPropertyMagicSuite.GlobalSettingPropertyMagicSuite.MacroGroupListMagicSuite.MacroHelpMagicSuite.MacroListMagicSuite.ReportBatchJobCountMagicSuite.ReportBatchJobListMagicSuite.ReportBatchJobPropertyMagicSuite.ReportConnectionSummaryMagicSuite.ReportJobCountMagicSuite.ReportJobListMagicSuite.ReportJobPropertyMagicSuite.ReportMacroCountMagicSuite.ReportPropertyMagicSuite.ReportScheduleCountMagicSuite.ReportScheduleListMagicSuite.ReportSchedulePropertyMagicSuite.SetReportPropertyMagicSuite.SubscriptionListMagicSuite.SystemPropertyMagicSuite.TenantImageMagicSuite.TopicHelpMagicSuite.VersionMerakiMeraki.CameraImageMeraki.ConfigurationChangeListMeraki.ConnectionMeraki.DevicePropertyMeraki.DeviceUplinkPropertyMeraki.EndOfLifeMeraki.NetworkClientListMeraki.NetworkDeviceListMeraki.NetworkEventListMeraki.NetworkListMeraki.NetworkPropertyMeraki.NetworkSwitchPortsListMeraki.NetworkSwitchStackListMeraki.OrganizationDeviceLicenseListMeraki.OrganizationDeviceLicensePropertyMeraki.OrganizationDeviceListMeraki.OrganizationDeviceListStatusPropertyMeraki.OrganizationInventoryListMeraki.OrganizationLicenseStatePropertyMeraki.OrganizationListMeraki.OrganizationPropertyMeraki.OrganizationUplinkUsageMeraki.WirelessNetworkClientConnectionStatsPropertyMeraki.WirelessNetworkClientLatencyListMeraki.WirelessNetworkClientsConnectionStatsListMeraki.WirelessNetworkClientsLatencyListMeraki.WirelessNetworkConnectionStatsPropertyMeraki.WirelessNetworkDeviceConnectionStatsPropertyMeraki.WirelessNetworkDeviceLatencyListMeraki.WirelessNetworkDevicesConnectionStatsListMeraki.WirelessNetworkDevicesLatencyListMeraki.WirelessNetworkLatencyListMicrosoftDataverseMicrosoftDataverse.ConnectionMicrosoftDataverse.CountMicrosoftDataverse.EntityDefinitionsListMicrosoftDataverse.EntityListMicrosoftDataverse.EntityPropertyListMicrosoftDataverse.ListMicrosoftDataverse.PropertyMicrosoftGraphMicrosoftGraph.ConnectionMicrosoftGraph.QueryObjectObject.ArrayCountObject.GraphObject.PropertyObject.TypeObject.UnpackObject.UnpackVariablesOpenAiOpenAi.AnswerOpenAi.CompleteOpenAi.ConnectionOpenAi.ImageQuickBooksQuickBooks.ConnectionQuickBooks.PropertySalesforceSalesforce.ConnectionSalesforce.ListSalesforce.PropertyServiceNowServiceNow.ConnectionServiceNow.CountServiceNow.CreateServiceNow.DeleteServiceNow.DictionaryServiceNow.ListServiceNow.PropertyServiceNow.UpdateShapeShape.AddShape.CloneShape.DeleteShape.FormatShape.HideShape.SetPropertyShape.SetTextSideroLabsOmniSideroLabsOmni.ConnectionSideroLabsOmni.ListSideroLabsOmni.ObjectSlackSlack.ConnectionSlack.MessageSlideSlide.DeleteSlide.DeleteSectionSlide.LinkSlide.MoveToSlide.RepeatSmtpSmtp.ConnectionSnmpSnmp.EnterprisePropertySolarWindsSolarWinds.ConnectionSolarWinds.SqlListSolarWinds.SqlTableSolarWindsServiceDeskSolarWindsServiceDesk.ConnectionSolarWindsServiceDesk.ListSolarWindsServiceDesk.PropertySqlSql.AnalysisTableTable.ColumnCountTable.DeleteTable.FormatTable.GraphTable.MergeCellsTable.MergeRowsTable.RowCountTable.SaveTable.SortTable.WorldMapTimeCalendarCronHumanReadableCronRunDateDateRangeDateTimeDateTime.IsInWorkHoursDateTime.WorkHoursDurationTimeSpanTogglToggl.ClientListToggl.ClientPropertyToggl.ConnectionToggl.ProjectListToggl.ProjectPropertyToggl.ProjectReportPropertyToggl.TimeEntryListToggl.TimeEntryPropertyToggl.UserListToggl.UserPropertyToggl.WorkspaceListToggl.WorkspacePropertyTwilioTwilio.ConnectionTwilio.SmsUkParliamentUkParliament.PetitionCountUkParliament.PetitionListUkParliament.PetitionPropertyVariableVariable.ImageVariable.ListVariable.PropertyWebWeb.ConnectionWeb.HtmlWeb.ImageWeb.QueryWeb.ScreenshotWeb.TableWeb.TextXlsxXlsx.AddAnalysisXlsx.EmbedZendeskZendesk.ConnectionZendesk.ListZendesk.PropertyZoho.DeskZoho.Desk.ZohoListZoho.Desk.ZohoProperty
LogicMonitor Macros (145)
Name Description Restriction Compatibility
[LogicMonitor.AccountProperty:]
Inserts a property of a LogicMonitor account.
[LogicMonitor.AlertAnalysis:]
Adds an Alert Analysis tab to the XLSX output document.
[LogicMonitor.AlertCalendar:]
Inserts a calendar with the worst (by default) alert for each day displayed (red for Critical, orange for Error and yellow for Warning).
[LogicMonitor.AlertCount:]
Inserts an alert count based on alert filter criteria.
Counts the number of alerts that were active in the reporting period, matching the filter supplied.
[LogicMonitor.AlertList:]
Inserts a list of alerts based on alert filter criteria.
Displays a list of alerts that were active in the reporting period, matching the filter supplied.
[LogicMonitor.AlertMap:]
Inserts a map with alerts displayed at their location.
Inserts a map with the worst alert at each location displayed (red for Critical, orange for Error and yellow for Warning). For alerts to appear on the map:
  • the devices being alerted on must have the location parameter set (as per the LogicMonitor documentation)
  • the devices must be in an alerting state as per the LogicMonitor.PercentageAvailability's way of filtering alerts
[LogicMonitor.AlertProperty:]
Inserts a LogicMonitor Alert property.
[LogicMonitor.AlertRuleList:]
Outputs a list of Alert Rule properties.
[LogicMonitor.AlertRuleProperty:]
Inserts an Alert Rule property.
[LogicMonitor.AlertStatus:]
Returns the current alert status of the specified item.
[LogicMonitor.AlertTable:]
Creates a table of alerts that were active in the reporting period.
Creates a table of alerts that were active in the reporting period. Note: The number of days for which alert data is retained in LogicMonitor varies according to whether you have a STANDARD, PRO, ENTERPRISE, MSP STANDARD or MSP PARTNER LogicMonitor set up. For some packages, alerts are only kept for 30 days, so please ensure that you are on one of the packages that keeps alerts for 60 days or more. For more information, check with your LogicMonitor account manager. More details about alert macros can be found at https://reportmagic.blogspot.com/p/reportmagic-alert-macros.html For the take parameter, there is a limit of 300. If your results will be 300 or more, set the take parameter in your macro to 299. You can then do a second macro where you use the skip parameter to skip 299 and take the next 299.
[LogicMonitor.AppliesToFunctionList:]
Lists the available AppliesToFunctions.
[LogicMonitor.AppliesToFunctionProperty:]
Inserts an AppliesToFunction property.
Inserts an AppliesToFunction property, given the AppliesToFunction name or ID.
[LogicMonitor.AppliesToList:]
A list of Resource (Devices), based on a LogicMonitor AppliesTo query or specific DataSource.
This macro performs the same test as the LogicMonitor DataSource "AppliesTo" field query a list of devices. Either the query can be used directly, or a ConfigSource, DataSource, DeviceGroup, EventSource, JobMonitor or PropertySource Name or ID can be specified. For more information, see the LogicMonitor LogicModule documentation.
[LogicMonitor.AuditEventAnalysis:]
Adds an Audit Event Analysis tab to the XLSX output document.
Adds an Audit Event Analysis tab to the XLSX output document, using data from the LogicMonitor audit logs (Settings => Audit Logs) and enhanced with additional data.
[LogicMonitor.BigNumberWidgetValues:]
Inserts a list of big number widget values.
[LogicMonitor.ClearCache:]
Flushes the LogicMonitor connection client's cache.
[LogicMonitor.CollectorExecute:]
Executes a command, Groovy or Powershell script on a Collector. Full
[LogicMonitor.CollectorGroupList:]
Inserts one or more properties for all Collector Groups.
Inserts one or more properties (or custom properties) for all Collector Groups.
[LogicMonitor.CollectorGroupProperty:]
Inserts one or more properties of a LogicMonitor Collector Group.
Inserts one or more properties of a LogicMonitor Collector Group property, given its ID.
[LogicMonitor.CollectorList:]
Inserts one or more properties for all LogicMonintor Collectors.
Inserts one or more properties for all LogicMonintor Collectors, optionally given the Collector Group ID or name
[LogicMonitor.CollectorProperty:]
Inserts one or more properties of a LogicMonitor Collector.
Inserts one or more properties of a LogicMonitor Collector, given its ID.
[LogicMonitor.CollectorVersionList:]
Inserts a list of Collector versions.
[LogicMonitor.CollectorVersionProperty:]
Inserts a Collector version property.
Inserts a Collector version property, given the Collector version.
[LogicMonitor.ConfigCheckList:]
Inserts a property of all LogicMonitor ConfigChecks.
[LogicMonitor.ConfigCheckProperty:]
Inserts a property of a LogicMonitor ConfigCheck.
Inserts a property of a LogicMonitor ConfigCheck, given the ConfigCheck name or ID.
[LogicMonitor.ConfigSourceGroupList:]
Inserts a list of ConfigSourceGroups
Inserts a list of ConfigSourceGroups. The "@ungrouped" group is included, but will appear as an empty string: "".
[LogicMonitor.ConfigSourceList:]
Outputs the specified property of LogicMonitor ConfigSources.
[LogicMonitor.ConfigSourceProperty:]
Inserts a property of a LogicMonitor ConfigSource.
Inserts a property of a LogicMonitor ConfigSource, given the ConfigSource name or ID.
[LogicMonitor.ConfigSourceXml:]
Inserts a LogicMonitor ConfigSource XML export.
Inserts a LogicMonitor ConfigSource XML export, for the specified ConfigSource (by ID or name).
[LogicMonitor.Connection:]
Specifies a LogicMonitor Connection.
Specifies a LogicMonitor Connection to use for the remainder of the report. Unless you are reporting on more than one LogicMonitor system, you should not include a [LogicMonitor.Connection:] Macro in your report. Instead, you can also create a Macro Parameter Default.
[LogicMonitor.ConnectionApiToken:]
Returns information about the Connection's API Token.
[LogicMonitor.ConvertToLiveWidget:]
Adds content to an HTML report that turns the output into a live widget.
Adds content to an HTML report that turns the output into a live widget so that the output contents can be put into a LogicMonitor Text Widget.
Partial
[LogicMonitor.Dashboard:]
Inserts a LogicMonitor Dashboard into the output document.
Inserts a LogicMonitor Dashboard into the output document, which works by creating and running a Report in LogicMonitor.
[LogicMonitor.DashboardGroupList:]
Inserts a list of Dashboard Groups.
[LogicMonitor.DashboardGroupProperty:]
Inserts a Dashboard Group property.
[LogicMonitor.DashboardList:]
Inserts a list of Dashboard properties.
[LogicMonitor.DashboardProperty:]
Inserts a Dashboard property.
Inserts a Dashboard property, or stores it in a variable for later use in other macros. This works with Dashboards that were present in LogicMonitor at the time the report was run.Note that the property 'WidgetsOrder' may be reported incorrectly by LogicMonitor, so it is recommended to use the 'WidgetIds' property instead to obtain an accurate list.
[LogicMonitor.DashboardWidgetList:]
Inserts one or more properties of a LogicMonitor Dashboard Widgets.
[LogicMonitor.DatamartSync:]
Syncs a connection's Datamart.
[LogicMonitor.DataPointList:]
Inserts a list of DataPoint properties.
[LogicMonitor.DataPointProperty:]
Inserts a DataPoint property.
Inserts a DataPoint property, given the DataSource and DataPoint.
[LogicMonitor.DataSourceGraphList:]
Inserts a list of DataSource Graph properties.
[LogicMonitor.DataSourceGraphProperty:]
Inserts a DataSource Graph property.
[LogicMonitor.DataSourceGroupList:]
Inserts a list of DataSourceGroup names.
[LogicMonitor.DataSourceList:]
Inserts a list of DataSource properties.
[LogicMonitor.DataSourceProperty:]
Inserts a DataSource property.
Inserts a DataSource property, given the DataSource name or ID.
[LogicMonitor.DataSourceXml:]
Inserts a DataSource XML export.
[LogicMonitor.DeviceConfigSourceFile:]
Outputs a property of a config file.
Outputs a property of either the most recent config file or the one specified by ID, on a Device for a given Config Source.
[LogicMonitor.DeviceConfigSourceInstanceList:]
Inserts a list of ConfigSource instance properties on a given Device(s) or Device Group(s).
[LogicMonitor.DeviceConfigSourceList:]
Inserts a list of ConfigSource properties with instances on given Device(s) or Device Group(s).
[LogicMonitor.DeviceConfigSourceProperty:]
Outputs one or more properties of a Device ConfigSource.
[LogicMonitor.DeviceCount:]
Outputs the count of Devices in the specified Device Groups.
[LogicMonitor.DeviceDataSourceList:]
Outputs a list of DataSources that have instances on a given Device, Devices, Device Group or Device Groups.
[LogicMonitor.DeviceDataSourceProperty:]
Inserts a property of a DeviceDataSource.
Inserts a property of a DeviceDataSource, given the DeviceDataSource name or ID.
[LogicMonitor.DeviceGroupList:]
Inserts a list of Device Groups, or Services within a Service Group.
Inserts a list of Device Groups, or Services within a Service Group. This lists Device Groups / Services that were present in LogicMonitor at the time the report was run.
[LogicMonitor.DeviceGroupProperty:]
Outputs a property of a LogicMonitor Resource Group (historically called a Device Group).
Outputs a property of a LogicMonitor Resource Group (historically called a Device Group). This macro handles Resource Groups that were present in LogicMonitor at the time the report was run.
[LogicMonitor.DeviceList:]
The list of devices in the specified device group(s).
Inserts a list of device names into your report, or to store them into a variable for later use in other macros. This works for device configurations that were present in LogicMonitor at the time the report was run.
[LogicMonitor.DeviceProperty:]
Inserts a Device property.
[LogicMonitor.DeviceSlaWidgetProperty:]
Inserts one or more properties of a LogicMonitor Device SLA Widget.
Inserts one or more properties of a LogicMonitor Device SLA Widget, given the Widget ID.
[LogicMonitor.DeviceTable:]
Inserts a table containing summary device data into your report.
Inserts a table containing summary device data into your report. This works for device configurations that were present in LogicMonitor at the time the report was run. Columns can be selected based on standard device properties.
[LogicMonitor.EscalationChainDestinationList:]
Obtains a list of Escalation Chain Destination properties.
Obtains a list of Escalation Chain Destination properties, for a given Escalation Chain.
[LogicMonitor.EscalationChainDestinationProperty:]
Inserts an Escalation Chain Destination property.
Inserts an Escalation Chain Destination property, given the Escalation Chain ID and Destination index.
[LogicMonitor.EscalationChainList:]
Obtains a list of Escalation Chains.
[LogicMonitor.EscalationChainProperty:]
Obtains an Escalation Chain property.
Obtains an Escalation Chain property, given the Escalation Chain ID.
[LogicMonitor.EventSourceFilterList:]
Inserts a list of EventSource Filters
Inserts a list of EventSource Filters.
[LogicMonitor.EventSourceFilterProperty:]
Inserts an Event Source Filter property.
Inserts an Event Source Filter property, given the Event Source ID and Filter ID.
[LogicMonitor.EventSourceGroupList:]
Inserts a list of EventSourceGroup names.
Inserts a list of EventSourceGroup names. The "@ungrouped" group is included, but will appear as an empty string: "".
[LogicMonitor.EventSourceList:]
Outputs a list of LogicMonitor EventSource properties.
Outputs a list of LogicMonitor EventSource properties, for grouped or non-grouped EventSources.
[LogicMonitor.EventSourceProperty:]
Inserts an Event Source property.
Inserts an Event Source property, given the EventSource name or ID.
[LogicMonitor.EventSourceXml:]
Inserts a EventSource XML export
[LogicMonitor.FinancialInformation:]
Outputs a property of LogicMonitor financial information.
Outputs a property of LogicMonitor financial information, for your LogicMonitor portal.
[LogicMonitor.Forecast:]
Forecasts future values and threshold breach dates.
Forecasts future values and threshold breach dates, based on LogicMonitor graph data.
[LogicMonitor.Graph:]
Retrieves data relating to Devices, Services etc. and displays in chart form in a report.
Retrieves data relating to Devices, Services etc. and displays in chart form in a report. Many of the parameters used by the LogicMonitor.Graph macro are also used by other macros, such as LogicMonitor.SummaryValue.

This macro should specify one of:

  • device, host, hostId, hosts, group, groups, deviceId, devices, deviceGroup, deviceGroups or serviceName.
  • graphName, graphId, overviewGraphName, overviewGraphId
  • dataSourceName or dataSource
[LogicMonitor.GraphSpecification:]
Obtains the specification of a LogicMonitor graph.
[LogicMonitor.HistoricSdtList:]
Inserts a list of historic Scheduled Down Time (SDT) properties.
[LogicMonitor.Image:]
Inserts a LogicMonitor image.
Inserts a logo, such as a company or login logo (the default).
[LogicMonitor.InstanceAnalysis:]
Adds an Instance Analysis tab to the XLSX output document.
Adds an Instance Analysis tab to the XLSX output document. This provides a summary of graph data for a specific Resource Group, DataSource and Graph.
[LogicMonitor.InstanceCount:]
The count of DataSource instances.
[LogicMonitor.InstanceDetailsTable:]
Presents detailed DataSource instance data in a table.
Presents detailed DataSource instance data in a table. See also Table Macros help.
[LogicMonitor.InstanceGroupCount:]
Counts the Instance Groups of the specified DataSource.
Counts the Instance Groups of the specified DataSource, whether those groups are manually or automatically created.
[LogicMonitor.InstanceGroupList:]
Lists the Instance Groups of the specified DataSource.
Lists the Instance Groups of the specified DataSource, whether those groups are manually or automatically created.
[LogicMonitor.InstanceList:]
Produces a list of list of instances of a given DataSource on a given Device.
[LogicMonitor.InstanceProperty:]
Inserts a property / properties for one or more DataSource Instances.
[LogicMonitor.IntegrationList:]
Inserts one or more properties for all LogicMonitor Integrations.
[LogicMonitor.IntegrationProperty:]
Inserts one or more properties of a LogicMonitor Integration.
Inserts one or more properties of a LogicMonitor Integration, given the Integration ID.
[LogicMonitor.JobMonitorList:]
Inserts one or more properties for all LogicMonitor Job Monitors.
[LogicMonitor.JobMonitorProperty:]
Inserts one or more properties of a LogicMonitor Job Monitor.
Inserts one or more properties of a LogicMonitor Job Monitor, given its ID.
[LogicMonitor.LastMeasurement:]
The last measurement to have been made on a specific datapoint.
The last measurement to have been made on a specific datapoint, between the start and end dates.
[LogicMonitor.LogAnalysis:]
Adds a Log Analysis tab to the XLSX output document.
Adds a Log Analysis tab to the XLSX output document, using data from the LogicMonitor audit logs (Settings => Audit Logs). Does not work in Report Studio.
[LogicMonitor.LogicModuleMetadataProperty:]
Inserts one or more properties of a LogicMonitor Logic Module's Metadata.
Inserts one or more properties of a LogicMonitor Logic Module's Metadata, given the Logic Module ID.
[LogicMonitor.LogicModuleUpdateList:]
Inserts one or more properties for all LogicMonitor Logic Module Updates.
Inserts one or more properties for all LogicMonitor Logic Module Updates, given the type.
[LogicMonitor.LogicModuleUpdateProperty:]
Inserts one or more LogicMonitor LogicModule Update properties.
Inserts one or more LogicMonitor LogicModule Update properties, given the name or local ID.
[LogicMonitor.LogItemList:]
Outputs a list of Log Items.
[LogicMonitor.NetscanGroupList:]
Inserts one or more properties for all Netscans.
[LogicMonitor.NetscanGroupProperty:]
Inserts one or more LogicMonitor Netscan Group properties.
Inserts one or more LogicMonitor Netscan Group properties, given the NetscanGroup ID.
[LogicMonitor.NetscanList:]
Inserts a list of LogicMonitor Netscan properties.
[LogicMonitor.NetscanProperty:]
Inserts a LogicMonitor Netscan property or properties.
Inserts a LogicMonitor Netscan property or properties, given the Netscan ID.
[LogicMonitor.NewUserMessageProperty:]
Outputs a LogicMonitor New User Message property or properties.
[LogicMonitor.PaymentInformation:]
Inserts a LogicMonitor payment information property.
[LogicMonitor.PercentageAvailability:]
Insert a single figure representing percentage DataSource availability.
Use the PercentageAvailability macro to give a single figure representing availability of a device or device-DataSource by getting a list of all Alerts, filtered by an AlertsFilter and determining the amount of time that it was NOT in an alerting state. If you provide no filter criteria, alerts at Error level and above are used for the calculation.
[LogicMonitor.PortalVersion:]
Inserts one or more properties of the current LogicMonitor portal version.
[LogicMonitor.PropertySourceGroupList:]
Inserts the 'Group' property for all Property Source Groups.
[LogicMonitor.PropertySourceJson:]
Inserts a Property Source JSON export.
[LogicMonitor.PropertySourceList:]
Inserts one or more properties for all Property Sources.
[LogicMonitor.PropertySourceProperty:]
Inserts one or more propreties of a LogicMonitor Property Source.
Inserts one or more propreties of a LogicMonitor Property Source, given the Property Source ID.
[LogicMonitor.Query:]
Returns a JObject representing the raw response from a LogicMonitor API query. Partial
[LogicMonitor.RecipientGroupList:]
Inserts one or more properties for all LogicMonitor Recipient Groups.
[LogicMonitor.RecipientGroupProperty:]
Inserts one or more LogicMonitor Recipient Group properties.
Inserts one or more LogicMonitor Recipient Group properties, given the Recipient Group name or ID.
[LogicMonitor.RecycleBinItemList:]
Outputs one or more properties for all Recycle Bin items.
[LogicMonitor.RecycleBinItemProperty:]
Inserts one or more properties of a LogicMonitor Recycle Bin item.
Inserts one or more properties of a LogicMonitor Recycle Bin item, given the item ID.
[LogicMonitor.ReportGroupList:]
Inserts one or more properties for all LogicMonitor Report Groups.
[LogicMonitor.ReportGroupProperty:]
Inserts one or more properties for a LogicMonitor Report Group.
Inserts one or more properties for a LogicMonitor Report Group, given the Report Group ID.
[LogicMonitor.ReportList:]
Inserts one or more properties for all Reports.
[LogicMonitor.ReportProperty:]
Inserts one or more LogicMonitor Report properties.
Inserts one or more LogicMonitor Report properties, given the Report ID.
[LogicMonitor.ResourceAnalysis:]UPDATED
Adds a Resource Analysis tab to the XLSX output document.
[LogicMonitor.ResourceGroupAnalysis:]
Adds a Resource Group Analysis tab to the XLSX output document.
[LogicMonitor.RoleList:]
Inserts one or more properties for all LogicMonitor Roles.
[LogicMonitor.RoleProperty:]
Inserts one or more properties of a LogicMonitor Role.
[LogicMonitor.SdtList:]
Inserts a list of current Scheduled Down Time (SDT) properties.
Inserts a list of current Scheduled Down Time (SDT) properties. Historic (i.e. those already finished) are not included.
[LogicMonitor.SdtPercentage:]
Outputs the percentage of time that a Website or Device is / was in SDT.
[LogicMonitor.SdtProperty:]
Inserts one or more properties of a LogicMonitor Scheduled Down Time (SDT).
Inserts one or more properties of a LogicMonitor Scheduled Down Time (SDT), given its ID.
[LogicMonitor.SingleSignOnProperty:]
Inserts one or more properties of a LogicMonitor Single Sign On.
[LogicMonitor.SlaWidgetValues:]
Inserts SLA Widget values.
[LogicMonitor.SnmpSysOidMapList:]
Inserts one or more properties for all LogicMonitor SnmpSysOidMaps.
[LogicMonitor.SnmpSysOidMapProperty:]
Inserts one or more properties of a LogicMonitor SnmpSysOidMap.
Inserts one or more properties of a LogicMonitor SnmpSysOidMap, given the SnmpSysOidMap ID.
[LogicMonitor.SummaryValue:]UPDATED
Presents one or more aggregations of graph data.
[LogicMonitor.SummaryValueList:]
Produces a list of summary values for instances.
[LogicMonitor.Threshold:]
Gets the alert threshold for a DataPoint.
Gets the alert threshold for a DataPoint. The alert threshold is a string comprising: a comparator (e.g. >), and 3 digits (warning, error and critical values).
[LogicMonitor.TrafficTable:]
Inserts a Netflow summary table.
Inserts a Netflow summary table for a Netflow-enabled Device or Device Group. Valid types are: 'Flows', 'Interfaces', 'Applications', 'Endpoints' or 'Bandwidths'. Each type results in a different table, similar to those be displayed on the 'Traffic' tab in LogicMonitor for Devices or Device Groups that are Netflow-enabled. Note: 1KB = 1,000 bytes, 1MB = 1,000 KB bytes and 1GB = 1,000 MB)
[LogicMonitor.UnmonitoredDeviceList:]
Inserts one or more properties for all LogicMonitor Unmonitored Devices.
[LogicMonitor.UnmonitoredDeviceProperty:]
Inserts one or more properties of a LogicMonitor Unmonitored Device (Resource).
Inserts one or more properties of a LogicMonitor Unmonitored Device (Resource), given the Unmonitored Device / Resource ID.
[LogicMonitor.UserApiTokenList:]
Inserts one or more properties of a all API Tokens for a LogicMonitor User.
Inserts one or more properties of a all API Tokens for a LogicMonitor User, given the User ID or Username.
[LogicMonitor.UserApiTokenProperty:]
Inserts one or more properties of a LogicMonitor User API token.
Inserts one or more properties of a LogicMonitor User API token, given an API Token ID and User ID or name.
[LogicMonitor.UserList:]
Inserts one or more properties for all LogicMonitor Users.
[LogicMonitor.UserProperty:]
Inserts one or more properties of a LogicMonitor User.
Inserts one or more properties of a LogicMonitor User, given the User ID.
[LogicMonitor.WebsiteCheckpointDataList:]
Outputs a list of raw data (values and timestamps) for a set of LogicMonitor Website Checkpoint raw data.
Outputs a list of raw data (values and timestamps) for a set of LogicMonitor Website Checkpoint raw data, given a Website ID, Checkpoint name and data point name.
[LogicMonitor.WebsiteCount:]
Counts the number of websites in the LogicMonitor account
[LogicMonitor.WebsiteGroupAnalysis:]
Adds a Website Group Analysis tab to the XLSX output document.
[LogicMonitor.WebsiteGroupCount:]
Counts the number of website groups in the account or parent website group
[LogicMonitor.WebsiteGroupList:]
Inserts one or more properties (or custom properties) for all Website Groups.
[LogicMonitor.WebsiteGroupProperty:]
Inserts one or more properties (or custom / inherited properties) of a LogicMonitor Website Group.
Inserts one or more properties (or custom / inherited properties) of a LogicMonitor Website Group, given the Website Group ID.
[LogicMonitor.WebsiteList:]
Inserts one or more properties (or custom / inherited properties) of all Websites.
[LogicMonitor.WebsiteProperty:]
Inserts one or more properties (or custom / inherited properties) of a LogicMonitor Website.
Inserts one or more properties (or custom / inherited properties) of a LogicMonitor Website, given the Website ID.
[LogicMonitor.WidgetStatus:]
Indicates whether a Widget is alive or dead.
Indicates whether a Widget is alive or dead, for a given Widget ID.
An unhandled error has occurred. Reload 🗙