User Profile
ALMIS_Rob
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Microsoft Teams Microphone Problems for Outgoing Calls
I'm getting a very similar issue. Currently affecting just myself (of a company of 30). And only on calls that I dial out to other company staff. If I dial any other contact, mobile, etc - it all works absolutely fine. If any other staff member calls me, it also works absolutely fine. Any call I make though, to a member of staff, they can hear me, I can't hear them, and inevitably it gives me an error screen of "Sorry, we couldn't connect you." It's like it's having an issue initiating my outbound audio stream - but only to colleagues.7.8KViews0likes2CommentsRe: Teams Meeting Link Formatting
DougBartley Oh very interesting, I'll need to wade through it - one thing immediately leaps out that as we're very very small we only have one policy for all users, and yet this issue isn't affecting everyone - but it's certainly worth the dive and I'll get back to you if I find anything that helps!7KViews0likes0CommentsRe: Match query giving odd answers
@Riny_van_Eekelen I've just worked out what I was missing. For each of the Match statements (MATCH($C5,Scoring!$E$4:$J$4) I was missing a return context on the end, in this case I've just put an extra comma, and now it works fine. =INDEX(Scoring!$E$5:$J$9,MATCH($C5,Scoring!$E$4:$J$4,),MATCH($D5,Scoring!$D$5:$D$9,))1KViews0likes0CommentsMatch query giving odd answers
Ave, I've got a workbook with 5 sheets. One of which is a scoring sheet with a grid: On the other sheets, I've got tables much like the following: And in the 'Rank' column I've got the following query: =INDEX(Scoring!$D$4:$J$9,MATCH($C5,Scoring!$E$4:$J$4),MATCH($D5,Scoring!$D$5:$D$9)) Which only kind of works. For some combinations it gives me a figure, but as you can see from the screenshot above, "Remote " & "Negligible" should give me a Rank score of 1. Not 20! Some combinations of Occurrence/Seriousness give me an "#N/A" error. I should note that the Occurrence & Seriousness columns are both drop down's validating against the column and row from the Scoring sheet, so there's no typographic type errors creeping in. I'm scratching my head a little here. Possibly a woods/trees moment.Solved1.1KViews0likes5CommentsRe: RDP files from CB's missing details
ALMIS_Rob Another update as of 21/02 - both our CB's stopped sync'ing properly to the SQL DB's around the 18th at 21:39 - having generated many many sync fails over the 17th and 18th. After 21:39 on the 18th, there are zero \Admin\ or \Operational\ entries in the event logs. MS are now taking a deeper look. Will update as and when I know more.3KViews0likes2CommentsRe: RDP files from CB's missing details
ALMIS_Rob Time to pile on the oddities. Having left CB2 offline overnight, I've fired it up this morning to take another crack at the issue. Now it appears to have synchronised properly with the SQL DB, the registry locations as referenced in my original post are now populated. Reviewing the event logs in \Applications and Services Logs\Microsoft\Windows\Remote-Desktop-Management-Service\Operational\ I'm now seeing 'Config Sync Succeeded' event ID 263. Rather than the Config sync failed with error: 0x80070057 that I'd been seeing in the \Admin\ folder. Interestingly, that config error did lead me to an article here: https://social.technet.microsoft.com/Forums/ie/en-US/320a7167-899e-4700-a254-15716c6952c6/remote-desktop-broker-config-sync-error?forum=winserverTS regarding the license model in use (by device // by user) and ours is actually not set. I looked at setting it, but the system threw a strop. Checking our license manager though, and it is applying them by user (our operating model) not sure if that's default, or if the UI simply isn't reflective of the settings in place underneath. That's a separate topic for investigation though. As it stands, we appear to be fully operational on both CB's. Will need to dig through the SQL hosts logs, see if I can track down why it wasn't synchronising. Will update again as/when I find time for that particular expedition.3KViews1like3CommentsRe: RDP files from CB's missing details
Quick addendum. After some brain boosting cheesecake, and playing to a hunch, I shut down CB2. Everything now appears to be working properly. RDP files getting populated with all the right data and such. So now the question is why the discrepancy between the two CB's, and diagnosing the nature of the fault and how to repair it. I'm still open to suggestions. Though I'm increasingly leaning towards nuking the services of CB2 and re-doing it.3KViews0likes4CommentsRDP files from CB's missing details
I've got an RDS farm running in Azure. The farm has 2 AD's, 2 CB's and 2 gateways - with 20+ session hosts setup. All the VM's are Server 2019. We built the farm last summer and have had smooth sailing for the most part. However an issue has now appeared and I'm at a loss as to why, and how to repair it. We added a new VM and session host last week, and clients logging into the gateway for the RDP link are getting an RDP file that is a fraction of the size it should be. Normally our RDP files are a little shy of 10KB, now they're about 0.5KB - and they're missing almost all of the arguments that should be otherwise present. This is affecting all pre-existing hosts, not just the new entry. Our CB's have a pair of Azure SQL DB's to talk to, both of which appear to be healthy within Azure and replicating between our primary and failover region just fine. Interestingly, a browse of the registry on CB1 into: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Terminal Server\CentralPublishedResources\PublishedFarms\"session_host_name"\DeploymentSettings shows all the details I'd expect to see, however browsing that same registry on CB2 and the keys for CertificateHash, CustomRDPSettings, DeploymentRDPSettings & fHasCertificate are all outright missing for the latest host (though they are present for the preceeding hosts). Thankfully users who have already downloaded the RDP file prior to today are unaffected, so that gives me a bit of grace to investigate and resolve the fault - but currently I'm at a bit of a loss. Any suggestions would be warmly received.3.1KViews0likes5CommentsXMatch / Index
Hi, My Excel skills are rusty to the point of atrophy and I'm trying to get my head around XMatch which is an entirely new function to me. I'm endeavouring to build a formula that will: Match text from 'Sheet1'ColumnB to 'Sheet2'ColumnB then match 'Sheet1'C1 to 'Sheet2'RowH4:S4 and paste the value from the meeting point of the two. At the moment I've got this: =INDEX('FY20_21 Version 2'!B5:T44,xmatch('Billing Summary'!B4,'FY20_21 Version 2'!B5:B23),xmatch('Billing Summary'!C1:D1,Billing_Month)) and it's giving me a #NAME? error which I'm struggling to fix/resolve. Any suggestions/advice would be welcomed. Regards,Solved1.1KViews0likes3Comments
Recent Blog Articles
No content to show