njoylif ✭✭✭✭✭

I've been running VM SQL 2008 EE and SAN (for both VM disk and data/log disk. I've also used local (way back). Recommendations/gotcha's - try to get different LUNs for data and logs and separate the two "files" across the two LUNs. - the more disks in your LUNs, the better the perfomance - make sure you have…

figured...thanks for the response.

yea, problem with that is [on Cisco gear] the IPSEC tunnel ID changes every 3 days or so depending on your settings, so given a peer, you can't automatically keep track of its tunnel over extended time without having to manually discover which OID goes to which tunnel for the given peer. Juniper routers treat IPSEC tunnels…

are you guys doing this going forward? I think my IPSLA is the same way, and I did run into this problem too. you may consider putting a note in the release notes or on the web somewhere obvious, as we tried installing the 3.5 addt'l web component after upgrading and it killed my addt'l web server (had to reboot).

not supported; obviously backup your DB prior to doing any work... check what you will be changing.... by highlighting all below....update by select from bottom to beginning of Update select * -- update ap SET PropertyValue=Replace(propertyvalue,'<email to change>','<new/updated email>' from actionsproperties ap where…

did you guys ever do this? I am looking to go to 100 for some features and am wondering if it will cause an issue. thanks

gotcha, I'll install local help files. did not do that. :) Polling set at default 30 min.

can you share your post config? I am having trouble with mine and keep getting 400 response from MESD. I know the 2020.2 provides more options in POST alert action...still can't get successfully opened.

adatole‌, et. al., where does it pull the URL/server from (11.5.2) now? used to be webservers/primary so you could change name to be load balanced URL, and just had to do this every time ran config wiz. (still have to for reports/jobs) Now is it [the macro] pulling from allEngines table....it doesn't even grab FQDN...so…

whitespaces and special chars can break easily. try: "The request was aborted.*Could not create SSL.*TLS secure channel"

Thanks for posting the resolution!

great example for beginners to aspx coding (but former life other languages) to get started on learning the relationships...

wluther‌ - TESTIFY! hcy01uk‌ - BRAVO!!! Thanks for sharing!

By the way, this report excludes rows with: VoipOperationResultTypes 1000, 1001 which are misconfigured and missing

awesome! glad it worked for you!

thanks for feedback. I wanted to include texts that use email addresses. is that what you might have seen?

I started in 6.3 RC but this works in 11.5. Finalized there. I'll check that out and maybe make a newer version from that if makes sense. Thanks for HU!

the report executes the stored procedure to gather output. you wouldn't run it on a schedule directly. do that through report scheduler.

sorry all, didn't get notification of comments. @mgibson - you would run as often as you want. you'd just schedule the report to run at whatever frequency desired. , - I used a temp table and the SQL is somewhat complex with variables and such, where the report tool probably couldn't send the code natively.

question is, what is the fix for this? I've just run into this for volumes of all things... Nice Report!

forgot to add pic:

no, wouldn't be able to give dates/times on this because its a calc function, where it counts the instances. If you wanted all of the instances, remove the count(*) in select statement and remove group by section. you will then return all of the specific rows matching your criteria

my only guess is that you do not actually keep detailed information for up to 9 weeks. check your admin pages and verify your detailed retention settings. Be careful about elongating those settings as there may be performance ramifications in going from say 7 days to 60 days. Your database will certainly get much bigger.…

D'oh...swiped that from another of my queries... try this: AND (LTRIM(MONTH(InterfaceTraffic_Detail.DateTime)) = (LTRIM(MONTH(getdate())) -1)) ) GROUP BY sorry about that.

whew....try this...I think the parens were off WHERE ( (Nodes.caption LIKE '%CARTR%' OR Nodes.caption LIKE '%USRTR%') AND (Nodes.caption NOT LIKE '%.Internet%' OR Nodes.caption LIKE '%USRT2NYNY1441%') AND ( (InterfaceName LIKE '%Ser%' OR InterfaceName LIKE '%Gig%') AND (InterfaceName NOT LIKE '%.%') ) AND (…

NP. it would go in your where clause...you'd tweak the specifics to meet your needs of the interfaces/nodes...i.e. (((InterfaceTraffic_Detail.Out_Averagebps/Interfaces.OutBandwidth)*100) > 45) AND ( LTRIM(MONTH(t.DateTime)) = (LTRIM(MONTH(getdate())) -1) -- last month ) -- ADD HERE - before last ')' of where clause ) GROUP…

Ah yes... #1, kind of cheating...My retention period for details is 7 days. hence, no date info...I just query the whole [InterfaceTraffic_Detail] table. #2, my settings are I pull stats every 5 minutes; my understanding is the stats give me min/max/avg for those 5 minutes. regardless of which system (node or SW chews…

great questions...this is old so I'll have to reveiw...give me a few. apparently I was out to lunch (far away) when commented..sorry about that.

definitely helpful for those "strange" areas that you just can't avoid having.