Browsing SharePoint libraries using WebDav

Using an application on our desktops (Windows 7) we wanted to save directly to our SharePoint 2010 libraries using the WebDav protocol.
After a few tests things seemed to work for uploading documents directly using this method, but after pushing it out to some of our users we ran into unsuspecting trouble.

A short term solution was to manually browse to the folder first using the ‘Open with Explorer’ method. This solved the issue, but we couldn’t have users doing this every time they restart their computer.

Unsure what to look for a magical google search produced this thread which pointed me in the right direction.

All that we needed to do was manually start the WebClient service on the computer. Once this service is running everything worked perfectly. After a couple more tests we verified this, then pushed out the settings to automatically start the service on startup via a GPO.

Total Views: (379)

La Dispute – Stay Happy There Lyrics

La Dispute – Stay Happy There Lyrics

Album: Room of the House (2014)

If I could play back every moment to you now
Spend lovesick and swollen on
Mornings mincing garlic on the counter by the sink
If I could hit the instant replay
Or know the every good day would any other catch you by surprise

When you say something is missing now, that’s what came back to me
Normal mornings like that and the night that I thought I’d forget where I left it
Making breakfast put coffee on the stove and scour every cabinet for the knife.

Don’t be shy
Don’t be kind
Somewhere snow collects and bends the boughs of pines

But doesn’t it seem a bit wasteful to you to throw away all of the time we spent
Perfecting our love in close quarters and confines
Isn’t it wasteful and I am terrified that it doesn’t feel painful to me yet
Somewhere on top of the high-rise there’s a women on the edge of a building at the ledge
and traffics backing up on 35
Its alright, I will fix whatever is not for sweetness in your life – just sit down
Please, sit down, here at the table and we’ll talk somewhere televisions light up in the night

I know things weren’t right
Maybe we were never cut out for the Midwest life
Maybe we’d have done much better on the coast
There are certain things I doubt we’ll ever know
I know you were getting tired of my drinking
I guess I was never cut out for the coke scene
and you worried I would end up like your father
and tired of the smoke and somewhere the wind blows

Somewhere a storm touches down north in Hudsonville
Somewhere the coffee starts to boil on a stove
And somewhere the wind blows
Somewhere the river levels finally getting low
Somewhere I’m up past dawn ’till
Somewhere you’ll live here, still somewhere you’ve already gone
Somewhere a radio is playing in a living room, says the city lacks the funds to fix the bridge
Somewhere the deer overruns so there introducing wolves back on the ridge
And from here in the kitchen I can here the neighbors in the alley hanging linens
and the men collecting trash bins in street
Your speaking to me, but I can’t understand you
The coffee is burning and all the times that we spent
That road trip out west
Through desert for the rest stops the kitsch we both collect
That winter the whole weekend we get we huddle by the stove
The cabin I had rented the unexpected snow
That visit for Christmas on television binges
We’ll see friends in Brooklyn
Drive south to Richmond
There’s traffic on the bridge, a woman on the ledge
and everywhere the wind, everything is happening at once.

Total Views: (2680)

RD Web Can’t Remote to PC externally

After installing a new Windows Server 2012 and setting up Remote Web Access (RD Gateway) and testing internally everything worked perfectly.

However when trying to remotely connect to a computer externally you can see the remote connection is just appearing as if you were trying to do this normally – not connecting via the gateway.

A quick search lead me here which had the easy fix for this!

1. Open IIS Manager
2. Browse down to Sites -> Default Website -> RDWeb -> Pages
3. While Pages is highlighted click on Application Settings.
4. Edit the DefaultTSGateway field and insert the external domain of the gateway into the value (eg. remote.yourcompany.com) This should match your SSL certificate.
5. Press Ok  – all done! No IIS restart required, too easy 🙂

Total Views: (1136)

Install Trend Micro WFBS 8.0 on Windows Server 2012 R2

After attempting to install Trend Micro WFBS 8 on our new Windows Server 2012 R2 installation I recieved the error of ‘unable to install .NET Framework 3.5’ or something similar. ‘Easy fix’ i thought, and downloaded the 3.5 and 4.0 .NET Frameworks – however neither of these would install.

A quick search led me to the following commands which I was able to use to install the required Framework after mounting the 2012 R2 ISO to the server.

C:\Windows\system32>dism.exe /online /enable-feature /all /featurename:NetFX3 /Source:D:\sources\sxs

Deployment Image Servicing and Management tool
 Version: 6.3.9600.16384

Image Version: 6.3.9600.16384

Enabling feature(s)
 [==========================100.0%==========================]
 The operation completed successfully.

Total Views: (1275)

Squid NTLM and AD Authentication

The final undocumented step of configuring Squid 3 NTLM (Active Directory) Authentication.

Depending on the order of installing squid3/winbind/samba your NTLM may not work even though all the acl’s are set up correctly and winbind is reporting AD users and groups perfectly via wbinfo -u

Edit /etc/group – find the line containing winbindd_priv and ensure the proxy user is added to the end. For example our line says winbindd_priv:x:120:proxy

Restart squid and bingo, NTLM with now work perfectly 🙂

Total Views: (989)

Missing metadata properties in Document Library

After splitting up one of our document libraries in SharePoint 2010 into multiple libraries a user noticed that upon viewing the properties of the document, the metadata fields were completely missing! Oh crap!

2013-11-19 15_18_49-Editing properties document.docx (Protected View) - Microsoft Word

 

Searching on Google brought various results but nothing particular to our case, mostly people uploading different versions of documents and having troubles.

After jumping into SharePoint Designer I began comparing a working library with a defunct one. A short time later I had noticed a small difference.

The default content type had a specified location under the ‘Display Form/Edit Form’ settings. If you view the content type properties in a web browser the settings won’t display as the content type was set to read-only, but viewing these in Designer shows the settings regardless.

All I had to do was ‘Allow Modifications’ in Designer (or select no to read only in a browser), then remove the Display and Edit form locations, save the settings, then set to read only again!

Presto, crisis aborted.

2013-11-19 15_23_04-http___perapp02_sites_eDMS

Total Views: (859)

WordPress Permalinks and Cloudflare 404s

I recently set up a website on a DigitalOcean VPS and connected to the domain to ButtFlare for it’s CDN caching. After the wordpress theme was set up a bit I turned on permalinks – and this caused 404’s on every page! (except the index). How strange… a quick google search showed some people altering their wordpress installation to point to www.domain.com instead of just domain.com – and this may have helped, but definitely didn’t solve my issue.

Checking the apache logs on the host shows the redirect working, but logging the error ‘file does not exist’ for the pages.

After searching way too long I came across this post on the WordPress forums which mentioned to change the AllowOveride setting in the apache config to ‘all‘  instead of ‘none – bingo!

The setting can be found in /etc/apache2/sites-enabled/000-default under the virtual host’s <directory /var/www/>  (note the ending slash is included).

2013-11-18 22_48_32-root@inklocations_ _var_www_wp-content_themes_ink

Total Views: (1599)

Monitoring RWW Connections

Recently scouring the internet for a way to monitor login/logout (connect/disconnect) of Remote Web Workplace connections through our SBS 2011 server proved to be a little problematic.
I found solutions such as RWWGuard/RWWProtect but it only seemed to support older SBS versions or had a purchase price.

Other links suggested searching through the IIS logs – but this didn’t seem efficient at all.

After a little more searching I found this post which detailed the location of the event viewer logs – excellent!

I came up with the following solution:

1. Open up Event Viewer (eventvwr.msc)

2. Expand Applications and Services Logs ->Microsoft -> Windows -> TerminalServices-Gateway -> Operational

Now you can see all the logs of connections and disconnections including time, username, ip connecting from, computer name connecting to, session length and session usage (bytes).2013-10-09 15_30_00-persbs01 - Remote Desktop Connection

But this wasn’t a completely perfect method as I wanted to do this a little quicker each time.

3. Right-click on Operational and select Create Custom View

4. Tick the Event level: Information box, and change <All Event IDs> to 302, 303 and press Ok

2013-10-09 15_28_50-persbs01 - Remote Desktop Connection

5. Name the custom view something relevant such as Remote Gateway Logging.

You’ll now be able to easily access the view each time you start event viewer!

2013-10-09 15_31_47-persbs01 - Remote Desktop Connection

Total Views: (1070)

Delete an email from ALL mailboxes in Exchange 2010/2013

Woke up this first thing this morning to see a little spam email from ‘St George Auto Motive Finance’ about a ‘Statement of Account’. Crap, I need to delete this email from all our mailboxes in our Exchange 2010 organisation. I’ve recently added a Exchange 2013 example as well.

2013-08-23 09_07_08-Inbox - alex@pnml.com.au - Microsoft Outlook

That isn’t good. So an email was sent to our ‘All Staff’ distribution list to aware them not to open it before I got into the office to remove it all.

Fired up Exchange Management shell and attempted to search for the message. However the results I received also included a few other legitimate emails that had been sent previously. I needed to narrow my search down! I came to the following result to get the only the results I expected.

Get-Mailbox -Server  "EXCHANGESERVER" | Search-Mailbox -SearchQuery 'from:STGEORGEAUTOMOTIVEFINANCE@stgeorge.com.au' -targetmailbox "Discovery Search Mailbox" -targetfolder "Inbox" -logonly -loglevel full

After logging onto the Discovery Search Mailbox I confirmed the results were correct, hoorah.. Now just for the delete command.

Get-Mailbox -Server  "EXCHANGESERVER" | Search-Mailbox -SearchQuery 'from:STGEORGEAUTOMOTIVEFINANCE@stgeorge.com.au' -deletecontent

But wait, it doesn’t work. It threw an error. I searched for an hour using different commands and approaching it different but it still didn’t work. I came across a post mentioning to use ‘Export Mailbox’ if you haven’t updated to SP1 but even this didn’t work. I even re-wrote it into a ‘for each $mailbox in $allmailboxes’ script.

However I came across this post which included a reference to this tutorial on how to add the Mailbox Import Export role to your account. I honestly thought permissions were fine as the log searching was working correctly but you DO need to be a member of this role for the -deletecontent switch to work. Make sure you restart your shell after joining the group.

Basically:
Create a Universal Security Group – $USG
Then run this command:

New-ManagementRoleAssignment -Name "Mailbox Import Export Administrators" -SecurityGroup "$USG" -Role "Mailbox Import Export"

Then restart your EMS and run the Search-Mailbox -deletecontent command again.

I then re-run the previous command and was asked for confirmation to delete the messages, entered the ‘Yes to All’ and watched it go through each mailbox and delete the one item as required.

Success 🙂

 

Exchange 2013 SearchQuery with Date Example:

Get-Mailbox | Search-Mailbox -SearchQuery {from:chall@mercycare.com.au and sent:January-20-2017} -targetmailbox "administrator@domain.com.au" -targetfolder "Inbox" -logonly -loglevel full

Total Views: (4536)

Hide All Disabled Users from Global Address List

A few users had left recently and I was notified to disable their account and remove their access – this had me a little worried as I had already done this a few weeks prior.
This was prompted because their emails were still showing up in the Outlook Global Address List.

Honestly I thought being a ‘disabled user’ that Exchange 2010 would do this automatically for me, but I guess not. I set off to find a script to hide all the disabled users from the GAL.
A quick search brought up this. But no results were produced.

After a little more searching I found the command that suited us perfectly as all disabled users are removed access then moved to our ‘Disabled Users’ OU.

Get-Mailbox -OrganizationalUnit "Disabled Users" | Set-Mailbox -HiddenFromAddressListsEnabled $true

Confirmed by checking the properties of a user in the EMC to make sure the ‘Hide from Exchange Address Lists’ was now ticked.
Success!

Total Views: (4271)