Quick StartThe ReportMagic MenuSchedulesBatch JobsReport StudioFilesProfileAdminAccount DetailsMeraki WebHooksGetting StartedAbout ReportMagicRegistering and Logging InSearching 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 StudioAPI 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.MetricsListAutoTaskAutoTask.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.QueryConnectWiseManageConnectWiseManage.ConnectionConnectWiseManage.CountConnectWiseManage.DictionaryConnectWiseManage.ListConnectWiseManage.PropertyCoreArrayArray.CountBreakBreakpointCalculateColorCommentContinueConvertDeleteDeleteRowDocumentBookmarkDocumentBreakDocumentInsertSectionDocumentSectionEmailEmailFileEmailReportExecuteForEachFormatTableCellFormatTableRowIfIgnoreIncInsertTableCellImageIsSetLinearRegressionLinkMapObjectRandomRegexRepeatRowSearchAndReplaceSectionSettingsSleepStopStopwatchStringStringIndexSubstringSwitchThrowExceptionUnsetWarningDatabaseDatabase.ConnectionDatabase.GraphDatabase.ListDatabase.TableDatabase.ValueDatabase.ValuesDataMagicDataMagic.SyncDictionaryDictionary.ItemDictionary.KeysDictionary.ValuesDocumentDocument.SetPropertiesFileFile.CopyFile.CopyOutputFilesFile.Csv.CellFile.Csv.RowFile.Csv.RowCountFile.Csv.TableFile.EmbedFile.ExecuteFile.ExistsFile.ImageFile.InsertFile.ListFile.LoadListFile.LoadObjectFile.LoadStringFile.LoadVariablesFile.Xlsx.CellFile.Xlsx.RowFile.Xlsx.RowCountFile.Xlsx.TableFunctionFunction.CallFunction.DefineGoogleGoogle.ConnectionGoogle.TableGraphGraph.AddDataGraph.DeleteDataGraph.RenameDataGraph.UpdateGravatarGravatar.ImageHighlightHighlight.BearerSummaryHighlight.BroadbandSummaryHighlight.CellularSummaryHighlight.ConnectionHighlight.FolderListHighlight.HttpServerPerformanceSummaryHighlight.IcmpTcpUdpPerformanceSummaryHighlight.MosPerformanceSummaryHighlight.PrecisionPerformanceSummaryHighlight.TunnelSummaryHighlight.WatchNodeListHighlight.WirelessAccessPointSummaryHubSpotHubSpot.ListJarrayJarray.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.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.SubscriptionListMerakiMeraki.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.MicrosoftDataverseConnectionMicrosoftGraph.QueryObjectObject.ArrayCountObject.PropertyObject.TypeObject.UnpackObject.UnpackVariablesOpenAiOpenAi.AnswerOpenAi.CompleteOpenAi.ConnectionOpenAi.ImageQuickBooksQuickBooks.ConnectionQuickBooks.PropertyReportMagicReportMagic.ApplyBrandReportMagic.BadgeListReportMagic.ConnectionListReportMagic.ConnectionPropertyReportMagic.ConnectionStatusPropertyReportMagic.FeedbackListReportMagic.FeedbackPropertyReportMagic.MacroGroupListReportMagic.MacroHelpReportMagic.MacroListReportMagic.ReportBatchJobCountReportMagic.ReportBatchJobListReportMagic.ReportBatchJobPropertyReportMagic.ReportConnectionSummaryReportMagic.ReportJobCountReportMagic.ReportJobListReportMagic.ReportJobPropertyReportMagic.ReportMacroCountReportMagic.ReportPropertyReportMagic.ReportScheduleCountReportMagic.ReportScheduleListReportMagic.ReportSchedulePropertyReportMagic.SetReportPropertyReportMagic.SystemPropertyReportMagic.TenantImageReportMagic.TopicHelpReportMagic.VersionSalesforceSalesforce.ConnectionSalesforce.ListSalesforce.PropertyServiceNowServiceNow.ConnectionServiceNow.CountServiceNow.CreateServiceNow.DeleteServiceNow.DictionaryServiceNow.ListServiceNow.PropertyServiceNow.UpdateShapeShape.AddShape.CloneShape.DeleteShape.FormatShape.HideShape.SetPropertyShape.SetTextSlackSlack.ConnectionSlack.MessageSlideSlide.DeleteSlide.DeleteSectionSlide.LinkSlide.MoveToSlide.RepeatSmtpSmtp.ConnectionSnmpSnmp.EnterprisePropertySolarWindsSolarWinds.ConnectionSolarWinds.SqlListSolarWinds.SqlTableSqlSql.AnalysisTableTable.ColumnCountTable.DeleteTable.FormatTable.GraphTable.MergeCellsTable.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.InstanceDetailsTable:]

Presents detailed DataSource instance data in a table.


Purpose

Presents detailed DataSource instance data in a table. See also Table Macros help.


Macro Compatibility

The macro can be used in all input document types and in Report Studio.


Parameter TypeDeprecation Message Preferred ParameterPresence Purpose Options Default
dataSource
StringDeprecateddataSourceName The DataSource name. N/A N/A
dataSourceName
String

Use instead of:

  • dataSource
Mandatory The DataSource name. N/A N/A
dataSourceInstanceGroupId
Int32Conditional The DataSource instance group id. If set, the dataSource parameter must also be set. N/A N/A
dataSourceInstanceGroupName
StringConditional The DataSource instance group name. If set, the dataSource parameter must also be set. N/A N/A
dataSourceInstanceId
Int32Conditional The DataSource instance ID. If set, the dataSource parameter must also be set. N/A N/A
dataSourceInstanceName
StringConditional The DataSource instance name. If set, the dataSource parameter must also be set. N/A N/A
graphId
Int32Conditional The graph ID. If set, do not set the 'graphName' parameter. You can use -1 to use raw data when there is no graph in LogicMonitor but you must choose the data point name as it appears on the 'Raw Data' tab in LogicMonitor, rather than the name in the DataPoint definition. N/A N/A
graphName
StringConditional The graph name. If set, do not set the 'graphId' parameter. N/A N/A
overviewGraphId
Int32Conditional The overview graph ID. N/A N/A
overviewGraphName
StringConditional The overview graph name. N/A N/A
serviceCheckPointName
List<String>DeprecatedwebsiteCheckPointName The website checkpoint name or names (required when type is set to WebsiteCheckPoint). N/A N/A
serviceCheckPointNames
List<String>DeprecatedwebsiteCheckPointName The website checkpoint name or names (required when type is set to WebsiteCheckPoint). N/A N/A
serviceName
List<String>DeprecatedwebsiteName The website name or names (required when type is set to WebsiteOverview or WebsiteCheckPoint). N/A N/A
serviceNames
List<String>DeprecatedwebsiteName The website name or names (required when type is set to WebsiteOverview or WebsiteCheckPoint). N/A N/A
websiteCheckPointName
List<String>

Use instead of:

  • serviceCheckPointName
  • serviceCheckPointNames
  • websiteCheckPointNames
Conditional The website checkpoint name or names (required when type is set to WebsiteCheckPoint). N/A N/A
websiteCheckPointNames
List<String>DeprecatedwebsiteCheckPointName The website checkpoint name or names (required when type is set to WebsiteCheckPoint). N/A N/A
websiteName
List<String>

Use instead of:

  • serviceName
  • serviceNames
  • websiteNames
Conditional The website name or names (required when type is set to WebsiteOverview or WebsiteCheckPoint). N/A N/A
websiteNames
List<String>DeprecatedwebsiteName The website name or names (required when type is set to WebsiteOverview or WebsiteCheckPoint). N/A N/A
widgetId
Int32Conditional The Widget id for dashboard graphs. The type parameter should be set to DashboardWidget. Finding the Widget id requires a few steps: you will need to use your LogicMonitor portal UI, enter developer mode in the browser, and find all 'li' elements (which are the Widgets) where the 'data_component_unique_name' attribute is like xxx_widget_xxx, where xxx are numbers. For example, 99_widget_123 is a Widget id of 123. N/A N/A
alignment
List<String>DeprecatedcolumnAlignments The column alignments. If fewer alignments are made than the number of columns, the last given value is used for the remaining columns. If omitted, no change is made. Supported values: Left, Right and Center. Usage: columnAlignments=Left;Right;Center;...In Excel output files, columns may be automatically aligned based on their type (e.g. numbers are always right-justified), and all column headers are ALWAYS left-justified so their text is not obscured by filter drop-down arrows in the Excel UI. N/A N/A
alignments
List<String>DeprecatedcolumnAlignments The column alignments. If fewer alignments are made than the number of columns, the last given value is used for the remaining columns. If omitted, no change is made. Supported values: Left, Right and Center. Usage: columnAlignments=Left;Right;Center;...In Excel output files, columns may be automatically aligned based on their type (e.g. numbers are always right-justified), and all column headers are ALWAYS left-justified so their text is not obscured by filter drop-down arrows in the Excel UI. N/A N/A
auto
BooleanOptional If 'true', the reporting period will be the last calendar month and neither startDate nor endDate parameters may be used.
  • true
  • false
false
autofit
AutoFitBehaviorDeprecatedautoFit The Word autofit behaviour. If omitted, no change is made.
  • Content
  • Fixed
  • Window
Content
autoFit
AutoFitBehavior

Use instead of:

  • autofit
Optional The Word autofit behaviour. If omitted, no change is made.
  • Content
  • Fixed
  • Window
Content
autoTitle
BooleanOptional Whether to auto title the graph.
  • true
  • false
true
autoTitleHeadingLevel
Int32DeprecatedtitleHeadingLevel If auto-titling the graph, the heading level to use.
  • From 1 to 6
N/A
columnAlignments
List<String>

Use instead of:

  • alignment
  • alignments
Optional The column alignments. If fewer alignments are made than the number of columns, the last given value is used for the remaining columns. If omitted, no change is made. Supported values: Left, Right and Center. Usage: columnAlignments=Left;Right;Center;...In Excel output files, columns may be automatically aligned based on their type (e.g. numbers are always right-justified), and all column headers are ALWAYS left-justified so their text is not obscured by filter drop-down arrows in the Excel UI. N/A N/A
columns
List<String>Optional The columns parameter is specified as a set of semicolon-separated definitions. There are 1-column options (e.g. columns=PROPERTY NAME), and several 3-column options (where the caret symbol is used to define 3 values e.g. columns=COLUMN LABEL^AGGREGATION^DATA POINT NAME). You can mix and match 1-column options and 3-column options in the same definition separated by a semicolon, e.g. specify two columns like this: columns=ALIAS;MY COLUMN LABEL^Property^device.CreatedOn. The 1-column option allows you to specify the DataSource Instance property to output and the column name in one go. Supported options are: Alias, DeviceId, DataSourceId, Id, Description, DiscoveryInstanceId, AlertEnable, DataSourceInstanceAlias, and Name, as well as any of the device properties mentioned at the end of this help (**) in the format device.XYZ. They can be used like this: columns=Name;Alias;AlertEnable;device.DisplayName. This example produces a table with 3 columns, with three headings: Name, Alias, and AlertEnable. The values output in the table will be the relvant values for the Device DataSource Instance in question. The 3-column options are specified delimited by the caret (^) in 4 variants: 1) The first is: COLUMN LABEL^AGGREGATION^DATASOURCE GRAPH LINE LEGEND NAME e.g. XYZ^max^max (In) where XYZ is the column title in the output, max is an aggregation (min, mean, max, count, etc. - more details below), and GRAPH DATAPOINT is the name of a data point that exists on the data source graph you have specified using the dataSourceName and graphName parameters. 2) The second 3-column specification is: COLUMN LABEL^Property^device.Propertyname e.g. columns=Device Display Name^Property^device.DisplayName. The available properties are specified at the end of this help. 3) The third 3-column specification is: COLUMN LABEL^calc^expression, e.g. columns=Total^Calc^1+2. This would produce a table with 1 column (titled Total) and the value in the cell is a calculation of 1 + 2. The expression can contain column label names (in curly braces) to use values from previous columns in the calculation, e.g. columns=Total^Calc^{Col1}+{Col2}. 4) The fourth 3-column specificiation is: COLUMN LABEL^Property^dataSourceInstance.PROPERTYNAME (replace capitalised text). The PROPERTYNAME text should be replaced with any of: Alias, DeviceId, DataSourceId, Id, Description, DiscoveryInstanceId, AlertEnable, DataSourceInstanceAlias or Name. For example: e.g. columns=My Column Name^Property^dataSourceInstance.DeviceId. * Supported aggregations are: Mean, Min, Max, First, Last, Sum, All, and Count. ** Supported properties used when the COLUMN LABEL^Property^device.PropertyName format is used, are: device.AlertEnable, device.AlertLevel, device.AlertsAreAcknowledged, device.AlertsAreInSdt, device.AlertStatus, device.AllAsJObject, device.AllAsJson, device.AutoPropsAssignedOn, device.AutoPropsUpdatedOn, device.CollectorDescription, device.CreatedOn, device.CurrentCollectorId, device.DeviceGroupIds, device.DeviceGroups, device.DeviceStatusdevice.DisplayName, device.DisplayName, device.EffectiveAlertEnabled, device.EnableNetflow, device.DeviceGroups, device.HostName, device.Id, device.InSdt, device.LastDataTime, device.Link, device.NetflowCollectorId, device.PreferredCollectorId, device.SdtStatus, device.AlertStatus, device.Type N/A N/A
comment
StringOptional Add a comment to make your document template more readable. The comment is discarded in the output document. N/A N/A
connectionName
StringOptional The name of the Connection. N/A N/A
criticalCellColor
ColorOptional The critical cell background color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. Color [A=255, R=192, G=0, B=0]
criticalCellTextColor
ColorOptional The critical cell text color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. N/A
dataSourceId
Int32Optional The DataSource ID. N/A N/A
dateTimeFormat
StringOptional The date/time format to use. Use the format specified here: https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings. When the format parameter is set to AllStrings, this is ignored unless you use NumbersAsStrings. Note however that this parameter only has an effect if all the values in the column are the same type. N/A yyyy-MM-dd
deCamelCaseHeaderRow
BooleanOptional Whether to de-camel-case the header row (i.e. convert 'MyHeaderText' to 'My Header Text'.
  • true
  • false
false
device
List<String>Deprecateddevices The Device Display name or names. N/A N/A
deviceGroup
List<String>DeprecateddeviceGroups The Device Group or Groups. Use "/" or no value in the deviceGroup parameter to reference the root folder. N/A N/A
deviceGroups
List<String>

Use instead of:

  • deviceGroup
  • group
  • groups
Optional The Device Group or Groups. Use "/" or no value in the deviceGroup parameter to reference the root folder. N/A N/A
deviceId
List<Int32>DeprecateddeviceIds The Device ID or IDs. N/A N/A
deviceIds
List<Int32>

Use instead of:

  • deviceId
  • hostId
Optional The Device ID or IDs. N/A N/A
devices
List<String>

Use instead of:

  • device
  • host
  • hosts
Optional The Device Display name or names. N/A N/A
emptyTableText
StringOptional If present, and the table has no rows, the specified text will be inserted in place of the table. N/A N/A
endDate
DateTimeOffsetOptional The end date in the format YYYY-MM-DD. N/A Midnight on the first day of this month
errorCellColor
ColorOptional The error cell background color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. Color [A=255, R=240, G=128, B=0]
errorCellTextColor
ColorOptional The error cell text color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. N/A
errorOnOverflow
BooleanOptional Should NCalc expression evaluation throw error on Overflow
  • true
  • false
true
excludeDataPoint
List<String>Optional The datapoints to exclude. N/A N/A
excludeSdt
BooleanOptional Whether to exclude periods of SDT from the macro results. Only works for Devices (not Websites, etc.). For the most accurate results, ensure that you have LogicMonitor permissions for ALL the Device Groups that the Devices are members of. When this is not the case, those Device Groups will simply be skipped.
  • true
  • false
false
failureText
StringOptional The text to display should the macro fail to execute. Note that a poorly-specified macro (e.g. omitting mandatory parameters) will still result in an error message. N/A N/A
fatalCellColor
ColorOptional The fatal cell background color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. Color [A=255, R=150, G=0, B=0]
fatalCellTextColor
ColorOptional The fatal cell text color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. N/A
flowDirection
Flows.FlowDirectionOptional The traffic flow direction. Used only with type=NetflowBandwidth.
  • All
  • In
  • Out
All
flowInterfaceIndices
List<String>Optional The traffic flow interfaces e.g. 1;2;3 for interfaces 1, 2 and 3. Used only with type=NetflowBandwidth. N/A N/A
fontSize
DoubleOptional Override the table style's font size. This is achieved by setting the font size for each table cell.
  • From 4 to 50
N/A
forecast
BooleanOptional Whether to include forecast data.
  • true
  • false
false
forecastTime
StringOptional The time to forecast.
  • 7days
  • 14days
  • 1month
  • 3months
7days
forecastTrainingTime
StringOptional The amount of data to use to inform the forecast.
  • 1month
  • 1year
  • 3months
  • 6months
1month
format
CellFormatOptional The cell format to use. Options are: 'AllStrings', 'Auto' or 'NumbersAsStrings'. Auto automatically sets the format for the whole column, or it can be forced to a string with AllStrings. To preserve date / time formatting (with dateTimeFormat) but treat only number columns as strings, use NumbersAsStrings.
  • Auto
  • AllStrings
  • NumbersAsStrings
Auto
graphType
GraphTypeDeprecatedtype The graph type. Defaults to Device. Options are: Device, WebsiteOverview, NetflowBandwidth, WebsiteCheckPoint and DashboardWidget.
  • Device
  • WebsiteOverview
  • NetflowBandwidth
  • WebsiteCheckPoint
  • DashboardWidget
Device
group
List<String>DeprecateddeviceGroups The Device Group or Groups. Use "/" or no value in the deviceGroup parameter to reference the root folder. N/A N/A
groups
List<String>DeprecateddeviceGroups The Device Group or Groups. Use "/" or no value in the deviceGroup parameter to reference the root folder. N/A N/A
hidden
BooleanOptional If true, the table will not be written to the report.
  • true
  • false
false
horizontalAlignment
TableHorizontalAlignmentOptional The horizontal alignment of the table on the page (does not affect Excel output).
  • Left
  • Center
  • Right
Left
host
List<String>Deprecateddevices The Device Display name or names. N/A N/A
hostId
List<Int32>DeprecateddeviceIds The Device ID or IDs. N/A N/A
hosts
List<String>Deprecateddevices The Device Display name or names. N/A N/A
if
StringOptional The condition that must be true in order for the macro to be executed/evaluated. Must either evaluate to true or false, for example: "3+5=8" or "contains('abcd', 'z'). N/A true
includeCondition
StringOptional The condition on which each row is included. Fields should be referred to based on the column name in curly braces, for example: includeCondition ='{CreatedOn}'>'{StartOfLastMonth}'. N/A N/A
includeDataPoint
List<String>Optional The datapoints to include. N/A N/A
infoCellColor
ColorOptional The info cell background color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. Color [A=255, R=0, G=213, B=213]
infoCellTextColor
ColorOptional The info cell text color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. N/A
maxAttempts
Int32Optional The maximum number of attempts when requesting data via the LogicMonitor API.
  • From 1 to 2147483647
N/A
mode
MacroModeOptional The mode in which variables are stored. In the legacy mode (default for Schedules), the variable created is a string and formatted. In the normal mode (default for Report Studio), the output variable is stored as a strongly-typed object, e.g. an Int32 or a List etc., rather than a formatted string.
  • Legacy
  • Normal
Legacy
monthsToReport
Int32Optional If set, sets 'endDate' to the 'start' plus the specified number of months. N/A N/A
normalCellColor
ColorOptional The cell color to use when no issue exists. Affects a cell or row based on the ThresholdAffects parameter. N/A
normalCellTextColor
ColorOptional The cell text color to use when no issue exists. Affects a cell or row based on the ThresholdAffects parameter. N/A
obfuscation
ObfuscationTypeOptional Obfuscation type. Use obfuscation to write reports where sensitive data is hidden. When used, ReportMagic guarantees that the same input string will map to the same output string for the whole of the report (but the next time the report runs, it will most likely map to a different value). If you use obfuscation, the property in your macro will not show up and instead, you will see a fake item of the obfuscation type chosen.
  • None
  • UkTown
  • DeviceName
  • Company
  • IpAddress
  • PrivateIpAddress
None
orderBy
StringOptional If present, sorts alphanumerically by this column. N/A N/A
orderByDescending
StringOptional If present, sorts reverse alphanumerically by this column. N/A N/A
pageWidthPercent
DoubleOptional The percentage of the available page that the table should occupy.
  • From 0 to 150
N/A
recurseDeviceGroups
BooleanOptional Whether to recurse Device Groups. Specify false to exclude child Device Groups.
  • true
  • false
true
repeatHeaderPerPage
BooleanOptional Whether to repeat the header row at the beginning of each page.
  • true
  • false
true
startDate
DateTimeOffsetOptional The start date in the format YYYY-MM-DD. N/A Midnight on the first day of last month
style
StringOptional Use Word's built in Table Styles (such as Grid Table 2 - Accent 1), or make your own in the Report Template. Built-in styles can be used in any document. Note that any custom styles you create, or customisations to the standard styles required that the styles exist in the input template XML (because they are not saved in Word documents by default). This can be achieved by assigning the style to a table, then delete the table and save the document. N/A Table Grid
tableName
StringOptional The table name (e.g. for XLSX output) N/A Table
take
Int32

Use instead of:

  • topN
Optional Only display up to this number of rows.
  • From 0 to 2147483647
N/A
thresholdAffects
ThresholdAffectsOptional What the threshold affects.
  • Cell
  • Row
Cell
thresholdColumn
StringOptional The threshold column. N/A N/A
titleHeadingLevel
Int32

Use instead of:

  • autoTitleHeadingLevel
Optional If auto-titling the graph, the heading level to use.
  • From 1 to 6
N/A
topN
Int32Deprecatedtake Only display up to this number of rows.
  • From 0 to 2147483647
N/A
type
GraphType

Use instead of:

  • graphType
Optional The graph type. Defaults to Device. Options are: Device, WebsiteOverview, NetflowBandwidth, WebsiteCheckPoint and DashboardWidget.
  • Device
  • WebsiteOverview
  • NetflowBandwidth
  • WebsiteCheckPoint
  • DashboardWidget
Device
useCache
BooleanOptional Whether to use the cache (where supported).
  • true
  • false
false
waitDuringUpgrades
BooleanOptional Whether to wait during LogicMonitor upgrades (i.e. execution essentially pauses).
  • true
  • false
N/A
warning
StringOptional If specified, adds a warning message for this macro. This is processed as an NCalc, and the warning message will ALWAYS be present and will be the value of the evaluated NCalc expression. N/A N/A
warningCellColor
ColorOptional The warning cell background color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. Color [A=255, R=240, G=192, B=0]
warningCellTextColor
ColorOptional The warning cell text color to use. If omitted, no change is made. Affects a cell or row based on the ThresholdAffects parameter. N/A
websiteId
List<Int32>DeprecatedwebsiteIds The website ID or IDs. N/A N/A
websiteIds
List<Int32>

Use instead of:

  • websiteId
Optional The website ID or IDs. N/A N/A
worksheetName
StringOptional The worksheet to save the result in the output Excel document (if so configured). Excel does not allow blank names, names above 31 characters, and the following characters: :, /, \, ?, *, [, ] N/A Table
writeToSpreadsheet
BooleanOptional Whether to write output to a spreadsheet.
  • true
  • false
N/A
xlsxTableStyle
XlsxTableStyleOptional The XLSX table style to use in any XLSX output document.
  • TableStyleMedium13
  • None
  • TableStyleDark1
  • TableStyleDark10
  • TableStyleDark11
  • TableStyleDark2
  • TableStyleDark3
  • TableStyleDark4
  • TableStyleDark5
  • TableStyleDark6
  • TableStyleDark7
  • TableStyleDark8
  • TableStyleDark9
  • TableStyleLight1
  • TableStyleLight10
  • TableStyleLight11
  • TableStyleLight12
  • TableStyleLight13
  • TableStyleLight14
  • TableStyleLight15
  • TableStyleLight16
  • TableStyleLight17
  • TableStyleLight18
  • TableStyleLight19
  • TableStyleLight2
  • TableStyleLight20
  • TableStyleLight21
  • TableStyleLight3
  • TableStyleLight4
  • TableStyleLight5
  • TableStyleLight6
  • TableStyleLight7
  • TableStyleLight8
  • TableStyleLight9
  • TableStyleMedium1
  • TableStyleMedium10
  • TableStyleMedium11
  • TableStyleMedium12
  • TableStyleMedium14
  • TableStyleMedium15
  • TableStyleMedium16
  • TableStyleMedium17
  • TableStyleMedium18
  • TableStyleMedium19
  • TableStyleMedium2
  • TableStyleMedium20
  • TableStyleMedium21
  • TableStyleMedium22
  • TableStyleMedium23
  • TableStyleMedium24
  • TableStyleMedium25
  • TableStyleMedium26
  • TableStyleMedium27
  • TableStyleMedium28
  • TableStyleMedium3
  • TableStyleMedium4
  • TableStyleMedium5
  • TableStyleMedium6
  • TableStyleMedium7
  • TableStyleMedium8
  • TableStyleMedium9
TableStyleMedium13

Examples (6)

Example 1:

This example produce a table with 6 columns. The first 3 columns output the relevant properties (and use the property names themselves as the column headings). The 4th column will be titled 'InBound' and uses the Max aggregation on the DataSource graph's line legend name 'Inbound : Number of inbound bits/sec.'. The 5th column will be titled'OutBound' and also use the Max aggregation with the 'Number of outbound bits/sec.' line legend name. The last column is titled 'Addition' and uses the Calc aggregation to sum the values from the InBound and Outbound columns:

[LogicMonitor.InstanceDetailsTable: devices=pdl-fw-01, dataSourceName=snmp64_If-, graphName=Throughput, columns=device.DisplayName;Alias;AlertEnable;InBound^Max^Inbound : Number of inbound bits/sec.;Outbound^Max^Outbound : Number of outbound bits/sec.;Addition^Calc^{InBound}+{Outbound}, orderByDescending=Addition, take=10, autoFit=Window]

Example 2:

The following example produces a table as in the first example, but colours the 'Addition' column's cells with a red background and yellow text when the cell's values exceed 1,000,000. This is achieved by using the thresholdColumn parameter (to specify which column any warning/error/critical parameters will apply), the errorGe parameter (to set the 'error greater than' value), the errorCellColor parameter (to set the cell's background color), and the errorCellTextColor parameter (to set the cell's text colour):

[LogicMonitor.InstanceDetailsTable: devices=pdl-fw-01, dataSourceName=snmp64_If-, graphName=Throughput, columns=device.DisplayName;Alias;AlertEnable;InBound^Max^Inbound : Number of inbound bits/sec.;Outbound^Max^Outbound : Number of outbound bits/sec.;Addition^Calc^{InBound}+{Outbound}, orderByDescending=Addition, take=10, thresholdColumn=Addition, autoFit=Window, errorGe=1000000, errorCellColor=#ff0000, errorCellTextColor=#ffff00]

Example 3:
[LogicMonitor.InstanceDetailsTable: devices=dev.panoramicdata.com, dataSourceName=WinCPU, graphName=CPU Usage, columns=Name^Property^Name;device.DisplayName]

Example 4:

This example has 4 columns. The first column specifies the name using the 1-column format. The next two columns are also specified using the 1-column format to output the device properties. The last column uses the Mean aggregation on the Busy line legend name (which can be found in LogicMonitor by going to the graph definition, and finding the Lines section, then by choosing the relevant item):

[LogicMonitor.InstanceDetailsTable: devices=dev.panoramicdata.com;test.panoramicdata.com, dataSourceName=WinCPU, graphName=CPU Usage, columns=Name;device.DisplayName;device.DeviceGroups;Mean CPU %^Mean^Busy]

Example 5:
[LogicMonitor.InstanceDetailsTable: devices=dev.panoramicdata.com, dataSourceName=WinCPU, graphName=CPU Usage, columns=Name^Property^Name;device.DeviceGroups]

Example 6:

This example is similar to the previous one, except that it uses the 3-column columns format to specify a custom column title (Device ID) for the dataSourceInstance.DeviceId property. If we had used the 1-column format instead (and used just DeviceId) then the column name would also be 'DeviceId', rather than 'Device ID' which is what we can achieve this way:

[LogicMonitor.InstanceDetailsTable: devices=dev.panoramicdata.com, dataSourceName=WinCPU, graphName=CPU Usage, columns=Name^Property^Name;device.DeviceGroups;Device ID^Property^dataSourceInstance.DeviceId]
An unhandled error has occurred. Reload 🗙