go to post Andrew Neilson · Sep 14, 2022 It's working as it should. I don't like it when things all of sudden start working with no explanation. Oh well. Thanks for taking the time to respond, I appreciate it.
go to post Andrew Neilson · Sep 14, 2022 Mysteriously, it has all of a sudden decided to start working this morning. Haven't touched it since yesterday:
go to post Andrew Neilson · Jan 8, 2020 So far, it makes perfect sense. The part I can't figure out is how to define the variable and actually get to the information.
go to post Andrew Neilson · Jan 8, 2020 Thank you, I'll keep that in mind. That said, I still need the code solution because we won't be upgrading for several months.
go to post Andrew Neilson · Jun 13, 2016 This is a sample of the email output:Date DB NAME Directory Size(GB) Free(GB) % Free Free Disk Space(GB)------------------------------------------------------------------------------------------------------------------------------------------------06/13/2016 LIVE H:\live\ 491.774 4.113 0.84 734.1706/12/2016 LIVE H:\live\ 491.774 0.955 0.19 734.2406/11/2016 LIVE H:\live\ 490.774 0.527 0.11 735.2206/10/2016 LIVE H:\live\ 486.774 0.435 0.09 739.1406/09/2016 LIVE H:\live\ 484.774 0.267 0.06 741.1106/08/2016 LIVE H:\live\ 483.774 0.946 0.20 742.1006/07/2016 LIVE H:\live\ 483.774 2.843 0.59 742.12 Last Purge Job:Started: 2016-06-13 07:53Finished: 2016-06-13 07:54Status: Success Mirror Status:Failover Mode: Arbiter ControlledConnection Status: Both failover members are connected to the arbiter Member Name: HSTSENSEMBLEP1/UVAHSPRDCurrent Role: PrimaryStatus: ActiveCurrent Type: FailoverJournal Latency: N/ADatabase Latency: N/A Member Name: HSTSENSEMBLEP2/UVAHSPRDCurrent Role: BackupStatus: ActiveCurrent Type: FailoverJournal Latency: ActiveDatabase Latency: Caught up Member Name: HSTSENSEMBLEP3/UVAHSPRDCurrent Role: AsyncStatus: AsyncCurrent Type: AsyncJournal Latency: Caught upDatabase Latency: Caught up Mirror file statusTime last file sent, Journal FileSecondary: 06/13/2016 - 07:02:59,MIRROR-LIVEMIRROR-20160613.023D/R 06/13/2016 - 07:02:59,MIRROR-LIVEMIRROR-20160613.023 Date Msg Header Count HL7 Msg Count Over 90 day count Journal Free Space (GB) Full Size--------------------------------------------------------------------------------------------------------------------------------------------------------------------------06/13/2016 297,695,134 143,720,796 1,535 611.55 1,249,445,774 06/12/2016 300,339,462 144,745,038 684 645.66 218,690,487 06/11/2016 300,175,355 144,585,713 602 620.45 3,660,130,114 06/10/2016 298,014,061 143,702,880 508 603.46 4,169,611,018 06/09/2016 297,530,982 143,507,436 338 596.53 4,114,797,465 06/08/2016 297,320,463 143,320,444 165 621.41 4,891,285,909 06/07/2016 297,207,426 143,164,757 0 654.68 2,958,572,967
