• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Network Application Monitoring /
  • NAM Open Q&A /
avatar image
Question by Paulo M. · Apr 21, 2014 at 08:57 PM ·

Exporting Site Information

My users frequently ask me what is the definition of the location sites loaded in DCRUM, so I though of parsing the location-*.config files and producing an HTML page for them to check out the site location information.

Then I though of looking in the database to see where this information is and I found it.

In the attached package, Get-Locations.ps1 is a Powershel script that gets from the database an XML document with the site location information.

Locations.xslt is an XML Stylesheet that transforms the XML in HTML. There's also a few more auxiliary stylesheets.

Export-Locations.ps1 is a Powershel script that gets the locations and produces the HTML output. 

To automate it, I've created a task to run the script every hour:

 <task ID="export_locations" name="Export Location Information - HTML" periodType="HOUR" period="1" timeLine="SERVER" offsetTime="00:01" timeout="00:15" recoverable="true">
  <command ID="0" name="Export Location Information">">
   <class>adlex.delta.scheduler.command.ShellCommand</class>
   <param>C:\Windows\system32\WindowsPowerShell\v1.0\powershell.exe</param>
   <param>-Version</param>
   <param>3.0</param>
   <param>-NoLogo</param>
   <param>-NoProfile</param>
   <param>-InputFormat</param>
   <param>Text</param>
   <param>-NonInteractive</param>
   <param>-File</param>
   <param>C:\Scripts\Export Configurations\Export-Locations.ps1</param>
  </command>
 
 </task>

Export-Locations.zip

Feel free to use and comment on it

Comment
Frans S.

People who like this

1 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

2 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Paulo M. · Apr 22, 2014 at 02:07 PM

By the way, to publish, I just dropped the html file under <server>/wwwroot/config and they are accessed via http://<server>/config/...

Comment
Frans S.

People who like this

1 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Paulo M. · Apr 21, 2014 at 08:58 PM

I'm also trying to do the same for Business Units and Software Services, in case anyone want's to help.

Comment
Frans S.

People who like this

1 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

esm siebel Dynatrace Managed license nam probe wan citrix dna rest api configuration mq alerting NAM 2018 dashboard dcrumadvisory reports css nam universal decode database mobileapp RUM ads sap nam console scripting nam server sequence transactions nam 2019 upgrade
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A