Technology in India

So its been a while since I have written a post, mainly due to the fact that I had a couple of weeks in India, followed by a couple of weeks of been unwell... I am going to give India the benefit of the doubt and blame the stop over in Dubai International Airport for my illness, mainly as I think its impossible to have gotten food poisoning from India taking into account the times.

So this was my second visit to India, the last visit about 3 years ago. Even in three years things have changed, WiFi is available everywhere and quite often its free! The cabling doesn't seem to have got any better, the words rat nest were muttered numerous times. Broadband now seems to be the norm, things seem to run faster than before.

The one thing that still amazes me is that the internet cafes and business are all still using old kit. For example CRT screens everywhere, in the UK a 17" flat screen (sometimes two) is the norm. In India they still seem to be clinging onto their 15" eye straining CRT's! Even the machines are old and usually running a dodgy version of Windows XP. For me this sums up India, they make things work for years and years. You just have to look around to see motorbikes and auto rickshaws that must be 20 years plus old, not to mention their archaic online train booking system!

Years of service but at what cost?
I firmly believe that most IT kit should be replaced every 4 years, especially in a business environment. The slower your machine is the less productive you are, fact! Granted in India labour is cheap (the average Indian takes home £550 a year, remember that's a average, in rural India people live on around £1.60 a day), so maybe making a machine last 10 years and that person been less productive somehow equates to a winning formula, it certainly seems to work as India's a booming economy.

But we are not India, we need to keep ahead in technology, continue to invest in technology to make us more productive and embrace IT to make our lives easier. I doubt whether that will be the last time I visit India, I think in 20 years time things will be very different.

How old are your machines? Are they due a refresh? Does my mental picture of India leave you thinking that your systems would be more at home in the Asian continent? If so give Fusion a call on 08451 221240 we will be happy to give you some free advise.

The iPhone 5, the best yet?

So far I have had an iPhone, iPhone 3G, iPhone 3GS an iPhone4S and now an iPhone 5!! I missed out on a iPhone 4 as I didn't think the upgrade was worth it and after the antennagate stories started appearing I decided not to touch it with a bargepole.

I should also mention my experience with the iPhone4S, the phone itself was great, nice and fast, loved the display and was well made. My problems started when it came to the battery power, it wasn't even lasting a day, I spent hours on the phone getting it replaced, no different. I did full factory resets, no different. I waited for the patch that was meant to solve the battery issues, no different. By this point I had become so frustrated with the product (when they offered me a second replacement) and the time wasted that I sent it back and got a basic HTC android phone. The android phone has served me well, but it was any cheap and cheerful and lacking in speed and memory.

Part of the problem with Apple is the fact that they keep everything so cloak and dagger, Microsoft release a new operating system and they make it available for every man and his dog to play with and give them feedback. HTC release a new handset, they let companies review them and get demo handsets before the product goes on general release. In my opinion this makes for a much better, bug free product.

So I have succumbed to a Apple product once again and got the iPhone 5, what can I say I fell for their marketing spiel once again. One of the main reasons that I wanted to go back to Apple for my phone is that I use iTunes a lot and the handset has deep integration with iTunes, I like to have my music on the go and have the ability to re-sync easily, the iPhone and iTunes enables me to do this easily. Apple also make very sturdy nice looking products, its a fact. In my opinion no one ever comes anywhere close to the apple products. A company like HTC makes a nice looking phone with great features then go and spoil it by supplying a cheap unsightly charger and a handset that feels cheap to the touch, I have seen it many times with most major laptop manufactures, they supply a good product but then go and spoil it with a generic bulky charger!

My iPhone 5 arrived the Monday after the Friday release date, I received a text message on the Monday morning from the delivery company (DPD), I initially read the text wrong and replied stating that I would like the item delivering the next day. DPD actually sent me the text message saying that the item was out for delivery for that day but would I like to change it? Must say impressive use of technology, if I had not been in that day I could have saved the driver a wasted visit. After reading the text again and kicking myself I managed to find the DPD depot number and the nice lady got in touch with the driver who confirmed that he would deliver the package, even though I had already requested that it be delivered the next day. Its nice to see that a bit of human intervention can be built into these automated systems. Well done to DPD's IT Department!

The phone itself is great, size wise its perfect, the screen is crystal clear, I am a bit disappointed about the change in the connector, only in that you could almost guarantee that someone somewhere would always have an iPhone adapter and now these won't work without a silly adapter. I also don't know why Apple didn't just use micro USB? Agreed Apples connector is of better design, but why create your own standard? Some things never change when it comes to Apple! Other than the change of design and screen size, its just like any other iPhone in terms of OS, Apple have made a few improvements but nothing ground breaking. I wonder do people actually use Siri in real life? They have also taken a backward step in terms of the mapping software, I am sure that they had good commercial reasons from this and a owner of a firm I can empathise with these. But as a consumer its a bit annoying to have an inferior product forced upon you, I liken it to taking Nova SRI in for a service and it coming back out just a bog standard Nova.... Once again only Apple could get away with this, I am sure they will have slipped this into their terms and conditions somewhere...

Windows 8 was going well!!!!

I have been getting on pretty well with Windows 8, I then decided to put a SSD drive in my laptop. Mainly just to speed it up, the small standard laptop hard disks are not the speediest of things.

So I took delivery of a 512gb Crucial M4 2.5" 7mm, it went in perfectly. I even managed to use the esata port on my laptop to transfer all my data. It took about an hour and half whilst at work, I want to do the majority of the setup in the office so that things like Direct Access worked, I then probably spent another hour are so on it over the weekend. It worked perfectly! It still seems to be working perfectly but when I come to license it I get;

Error Code:
0xC004C4AD

Genuine Validation detected tampered Windows binaries

The only article I can find online is;
http://answers.microsoft.com/en-us/windows/forum/windows_cp-windows_install/windows-8-consumer-preview-error-code-0xc004c4ad/204e539e-c395-46fd-be98-01acd5a190ef

Therefore its looking like another rebuild... Far from impressed!

God knows why it happened, one theory I have is regarding the firmware upgrade for the SSD drive, the software didn't work with UEFI and in the end I used a Windows To Go installation on a USB drive to install the update... Or maybe the DVD that I did use is now corrupt, or I could just have a virus on my machine as I am currently unprotected, I am waiting for Microsoft to release a version of Intune that will work on Windows 8.... I will make sure I put on McAfee just to be on the safe side when I rebuild it again..

By the way the SSD is like lightning!

Windows 8 - A Second Opinion

Jamie recently shared his business-focused experiences with Windows 8, so I thought I'd add my more casual views to the mix...

In summary (for those who don't want to read any more than they have to!) - I like it. As with any new operating system there are things that I haven't quite got used to, but weighed against these slight annoyances, are a bunch a nice changes:

 --WHAT I LIKE--

1. Apps

Being a Windows Phone user (and advocate!) I like the metro modern tiles. This screen replaces the Windows 7 Start menu, but in my opinion, having used it for a few weeks now, it's no slower than using the start menu and you get the added benefit of live tiles.

I also like being able to snap the apps to one side of the desktop. This is great for when your using one monitor and want to keep an eye for any emails coming in.

2. The New Look Windows Explorer
Windows Explorer now has a ribbon just like Office 2010. This puts a lot of the options, such as show/hide hidden files, file name extensions within much easier access.

Microsoft have also brought back the ^ button next to the address allowing you to quickly navigate to the folder above the one you are currently in.

3. Achievements
I'm an XBOX gamer and I'm not afraid to admit that I'm slightly addicted to achievements. So what can be better than getting some easy and free achievements from the standard Windows games like minesweeper and solitaire? Awesome!

4. The New Task Manager
I love access to more detailed system information and the new task manager gives you just that. It starts with a simple list of running applications and their current status, but click the more details tab and you get a nice presentation of the running processes and system performance. Under the user tab you can even see running processes grouped by user.

5. More Accurate Progress Bars
This may seem like a trivial point, but it always irked me that when transferring files the progress bar constantly changed it's estimate and never seemed correct --- 5hrs remaining, 2hrs 30min remaining... right. The new presents more information about the speed of the transfer and gives you a more accurate (as far as I have tested) estimate of the time remaining.

6. Startup and Shutdown Times
Windows 8 loads and shutsdown quicker than any previous Windows (that I can remember).

--WHAT I DON'T LIKE--

1. Closing Apps
Why is it so difficult to close an app? I don't like a cluttered desk, or a cluttered desktop. Equally I don't like applications running unnecessary in the background, even if they are in a suspended state.

Apps don't have a cross/close button at the top right. Instead you have to move your cursor to the top of the screen and then drag (holding the mouse button) to the bottom on the screen . Alternatively you can use the shortcut Alt+F4

2. Navigating Between Apps
I also don't understand why when you close an app it doesn't go back to either: the last app you had open, the home screen, or the desktop. I find that quite often it will leave me with a blank screen.

So when you close down Internet Explorer after viewing a link someone sent you in an email it doesn't automatically go back to the email.

3. The Messaging App
This little app is supposed to make sending messages over your favourite social networking sites easier. But it's clunky and in my opinion unnecessary. The feature should have just been built into the people app, which does an excellent job of combining your contact information from a number of sources.

4. Sizing
The whole Windows 8 Experience is designed to be touch-friendly. This is great if you are using a touch device but if you're not I find that everything is scaled unnecessarily large. These can be tweaked slightly - you can tell the new start screen to display more tiles for example.

A couple of Shortcut Keys that might come in handy:

Win+Q: Search apps (or just start typing from the home screen)
Win+W: Search settings
Win+F: Search files
Win+D: Open desktop
Win+,: Peek at desktop
Win+B: Back to desktop
Win+Z: Get to app options
Win+.: Snap app to the left
Win+Shift+.: Snap app to the right
Alt+F4: Close an app
Win+X: Open system utility settings menu
Win+PrntScrn: Take screenshot and save to Pictures
Win+Tab: Open switch list
Win+T: Preview open windows in taskbar

How Toy Story 2 was saved through system backups!

Toy Story 2 is one of the most successful animation movies of all times and has so far grossed over $485 million over the world. Despite this did you know that the movie was nearly lost after a designer accidentally deleted all the film’s files?

Pixar have created a short video showing how their Toy Story 2 files were very  nearly lost. This is the perfect example of how a business can lose millions of pounds of data through a simple error. Luckily in Pixar’s case the data had been backed up by one of the team and they could restore it by getting their computer. However if Galyn hadn’t wanted to work from home we may never have seen Toy Story 2. Today Pixar would only need to install a backup product such as Fusion's Offsite Backup to restore their files with ease.

Windows 8 - The Marmite effect?

Marmite you either love it or you hate it right? Windows 8 in my opinion is in the same mind set as Marmite. That said I used to hate olives, a wise person once told me that be persistent with eating olives and one day you will love them..... Maybe its the same with Marmite?

I have been running Windows 8 now for about a month along with the Office 2013 preview, when I eventually got my system up and running (more about that later) I found myself hating it to start with, but I can now fondly look back over the last 4 weeks and see it as a learning curve.

The install of Windows 8 is very fast, I recon you can build a system from scratch in about 15 minutes, the whole process is very slick and it doesn't take a rocket scientist. I personally opted for the UEFI option as opposed to the standard legacy BIOS boot, this caused me a few issues. Mainly because I was using our Zalman virtual cd drive which doesn't seem to detect the presence of UEFI bootable media, after a couple of failed attempts I quickly burnt the image to a DVD and 12 minutes later I was presented with the metro modern desktop.

There are a few drivers missing for my system (Dell Latitude E6420), namely the fingerprint reader and the SD card reader, both of which I very rarely use so will put up with until the official Windows 8 drivers are released. Again maybe its me been a little OCD, but what is the point making your system unstable by installing drivers that weren't designed for it?

I built my system at home but as this was a work machine I needed it to be part of the domain and it would then benefit from our DirectAccess connectivity back to HQ. I setup our firewall to allow PPTP access, joined it to the domain, did a quick "GPUPDATE / force" and before you know it I was up and running.

I quickly installed my favourite apps, I like to keep my system relatively clean, I guess its a bit of a OCD thing I have going. On the whole it went relatively smooth though I did hit a couple of snags;

1. Activating caused me a few issues, I am not sure why yet. I suspect its because Windows 8 Enterprise was looking for our internal activation server (which we don't have), the resolution to this was to use the following command in an elevated command prompt slmgr.vbs -ipk "YOUR_PRODUCT_KEY".
2. I then came to install our helpdesk software, this needed .NET 3.5 windows feature enabling to install correctly. Seems that Windows 8 uses Windows Update to install new features, I am guessing that this is what gives the OS a much smaller foot print. Anyway I got round this my using the CD and the dism command "dism.exe /online /enable-feature /featurename:NetFX3 /Source:f:\sources\sxs", which effectively installs the feature from the source CD. I think the reason for this was that we are using an internal Windows 8 R2 servers as our WSUS server, I am assuming that an update will be released or we may have to upgrade this to Windows 2012.

In my initial period of getting used to Windows 8 I have found myself searching Google for lots of answers, you are usually greeted by a few pages of people experiencing similar issues. After all the product has only been available in its final incarnation since the 16th August, 2012, people who are running this software are in the minority, I would like to call us pioneers..... Here are the answers to a few things that I found myself pondering over;

How do I get to the desktop?
A couple of ways I have found, when in metro modern you can press the Windows button (The Windows button will become your friend in Windows 8), you can also type Desktop and click on the icon, I have also found escape works but I think you need to have some non native Windows 8 apps running for this to work. You can also alt and tab if you are in the modern desktop

Where has my show desktop icon gone?
Easily just put your mouse in the bottom right hand corner, right click and press show desktop.

How do I see all my apps that are installed?
Right click in modern and select the All Apps icon in the bottom right, this is especially useful if you want to see an app that you have hidden.

How do I shutdown my machine?
Again a couple of options, the easiest I have found is by pressing the Start+I combination which brings up the settings for the current context. You will always have the power icon on there and you can just select this and decide the computers fate.. You can also use the Alt F4 shortcut when you are on your desktop.

What is my charms bar?
This is a context sensitive system wide bar with a total of 5 buttons; Search, Share, Start, Devices and Settings. While the buttons appear from the right side, a notification panel appears from the left side displaying the Current Time, Day, Date, Internet Connection and Battery Power Status. You can get to it by moving your mouse to the top right or pressing Start+C.

Where has my Windows Aero gone?
Microsoft have dropped this feature stating it was "dated and cheesy", there are people who are currently building modifications to bring this back. But is it worth it for something that brought very little value? Just use alt tab or hover over the relevant application icon on the taskbar.

What happened to my easy to find options in the start menu?
There is a hidden basic start menu which will get you to all your much loved areas of Windows, device manger, system menu etc.... Just hover over the bottom left of any screen until the modern UI icon pops up and then right click. You can also press Start+X at any point.

How do I name my networks?
Any wireless network seems to name its connection by its SSID which is fine. Any wired network just gets named Network 1, Network 2 etc... I have found a way in the registry to change this but no easy way in the UI, would love to hear if someone has found a way or Microsoft's reasoning for taking away something that was easily done in Windows 7.

So to a couple of things I really like;

• The file copy has a graph, nice to see what sort of throughput you are getting when you are copying files.
• Task Manager looks great and gives you lots more information
• Spell Check is now in IE and also in many modern desktop apps
• You can uninstall apps directly from the modern desktop
• Once we get better support from our existing apps to use things like tiles in the modern UI I think we will find ourselves spending less and less time on the desktop and more time in metro modern.
• It looks clean
• It boots and sleeps much faster.
• I like the simplified way of categorising networks, private or public and the fact you can switch between them by turning sharing on or off
• Like the idea of a store, though not used it much yet! There is a Remote Desktop modern desktop app which you can install.
• Ability to use Skydrive, I am told that DRM it also built into this which can help with company data leakage.

I actually think we also need to look at the new Microsoft tablets that are coming out, these will be running Windows 8 & Windows 8 RT (ARM based version), once you have one of these devices running alongside your desktop, all based on the same code base you have a very powerful tool indeed.

At Fusion we need to start exploring the management side of Windows 8 and ensure that we can support it effectively, we have already started this so watch this space. Depending on how our internal testing goes we will be looking all rolling out Windows 8 to certain clients in the next 6 - 12 months. If you are interested in what Windows 8 can do for you, why not get in contact with us?

I have just scratched the surface here, but what I hope to get across is don't believe everything that people are saying about Windows 8, its not the next Vista. Vista was disappointing, even Microsoft admit this, but Windows 8 is more like olives. If you try it enough and persist you will end up thinking how did you live without it.

The perfect power backup for servers

So recently we had an issue where our servers were all unavailable on a Sunday morning, we could only assume a powercut had taken place or one of the circuits had tripped.

To answer the posts subject, "The perfect power backup for server" would of course be an inline generator, effectively the power goes off, batteries take care of the providing power for a few seconds whilst the generator kicks in. Of course for most of us our IT systems do not warrant this sort of expense, you tend to find generators are used in data centres and large companies that host their own servers.

That said there is lots we can do to make sure that we look after our servers correctly.

So when a power outage occurs in my opinion you need a UPS (Uninterruptable Power Supply) that will do the following and in this order;

1. Power your servers until the battery only has enough juice to shutdown the servers. Obviously if the power is restored by such time then great! I would say that 10 minute or so on battery is more than adequate. If the power is off for 10 minutes you can assume its going to be a substancial powercut.
2. Once the battery only has enough juice to power down the servers gracefully the UPS should issue the shutdown command to all the servers that it is connected to.
3. The UPS should then wait a period of time and then turn off the output to the servers connected to the UPS. Now many UPS's have multiple output ports so you can setup these outputs to turn off after different amounts of time etc..
4. Once power is restored the UPS should wait a period of time to restore power to the output ports to make sure the power isn't flapping. I would say that 60 seconds of continuous power is probably enough to safely say that power has been fully restored.
5. Once power is restored the servers should automatically boot back up again and thus leave it in a usable state.
6. You need to be notified of whats happening every step of the way. No point having problems and finding out about them first thing Monday morning or when an irate manager calls you.

Many of our clients just have a couple of servers and one UPS, the setup for these is pretty simple and usually consists of a server having a link to the UPS via USB and having some control software installed. In Fusion's comms room we have around 10 servers, 2 POE Switches, 4 routers & one firewall. To support this we have 3 UPS's each with a network management card installed, this means that we don't have to rely on the server been up at look at what going on and to configure the UPS.

Even as I write this more and more scenarios come into my mind, lets take a look at some of them and how we have tackled them;

• The first thing is to make sure that your UPS is working correctly. I have seen it time and time again, UPS's with red flashing lights usually mean that something is wrong. Do you know that if you let your UPS drain more than 30% you will almost definitely cause long term damage to it? One of the things you need to ensure is that your UPS is never allowed to drain fully, we tend to configure them so that they shutdown the output when they reach 30% no matter whats still running. You can even put a multimeter across the live and neutral points, find teh voltage and work out if the battery is faultly, search for lead battery condition and all will be revealed. Looking after batteries is a fine art in itself.
• Its worth doing a running test of a UPS to check that things are functioning correctly. I have heard of people using electric heaters to do this! If its not functioning correctly replace the battery. Did you know that most batteries depending on how they have been treated will only last between 3 & 5 years!
• You need to make sure that you test the run time with the maximum possible load going through the UPS, always work on the worst case scenario. You need to be careful of overloading the UPS.
• Are you using the right plugs on your UPS with the right fuses in? Kettle leads can quite often have either 5 or 10 amp fuses in. Some UPS's can easily pull more than 5 amps!
• If the servers do shutdown the UPS should only power them back up when the power supply is stable again and when the UPS(s) have enough power to start them up and then shut them back down should another power failure occur.
• What about if your servers have redundant power supplies? Well this again opens another can of worms. Do you just plug both the PSU's into the same UPS? Surely this is a single point of failure? Do you plug one PSU into the UPS and one into the wall socket? Do you have multiple power sources / multiple ways coming into the room? In a ideal scenario you would have two UPS's that talk to each other and each UPS into a different power supply / way and plug PS1 into one UPS and PS2 into the other... The only thing is UPS's are not cheap! You have also got to make sure that your switch is powered by a UPS otherwise if your servers loose comms to the UPS the UPS will be unable to issue the shutdown command once the runtime threshold has hit.
• Lets just say you do plug one PS into the UPS and the other into the wall (obviously using a surge protector) what happens if the power goes on the UPS side? Well eventually the UPS will shutdown these servers even though they have a perfectly good power supply coming from the wall socket.
• The way you configure servers to start automatically when power is restored is to enable the setting on the BIOS to power on with AC connect (please bear in mind that this setting is usually disabled by default). Basically if the servers shutdown via the UPS and they still have a good power supply from the other PSU to servers will never switch on again because effectively they never lost power. Once way around this I guess is using some kind of management card for the server that allows you to power it on remotely. Note: You can enable this setting on Dell servers with Open Manage installed by using the omconfig command line, search the web for more details there is plenty of documentation on this.
• What happens if the power goes off on both power sources the UPS eventually shutdown the servers, but as the servers are shutting down power is restored. I guess in this scenario you are in a similar position to my last bullet point.
• What about yours comms kit? Most comms kit doesn't have support for UPS communications! It is this sort of kit that will drain your battery to its last few percent.

So back to the problem that we had. It was quite simple really. We have got 3 UPS's, one for all our comms kit, and the other two to share the server load. The one running the comms kit is a Dell UPS Tower 1920W HV, and the other two are a APC Smart-UPS 2200 RM & a APC Smart-UPS 1500 XLM, as I have said before they have all got network management cards in. So the servers were split over the two UPS's and the redundant PS were all connected to a power block which was then connected directly to the Dell UPS. So the series of events that occurred were that the power was on and off all Sunday morning between 7 & 8 culminating in at least one of the APC's transferring all its load to the Dell UPS and around 10.7 AMP's going though something that was only ever designed to take a maximum of 8 AMP's! This blew the fuse (see below) to the UPS supplying all our comms kit and at this point most of the servers and it wasn't long before there was silence in the server room... Our engineer Ryan was dispatched later that afternoon to get things up and running again. So we have learnt a lot from this incident and have now put in measures so this will not happen again and so that we have better visibility of whats going on.

We still have the three same UPS's, one running the comms kit which will do so for about a hour until the battery is about 30%, obviously if we do loose power for a long period of time the management interface will always be up as this uses very little power. The servers are still split across the other two UPS's but now the redundant power supplies are setup to goto a APC AP7920 Switched Rack PDU, this also has a management interface so providing that we have comms (one of our 4 links coming into the building) we can always get onto all the UPS's and PDU. We have setup the PDU to wait 15 minutes if there is a disruption to its power source, this should mean that if the servers do start to shutdown and power gets restored mid shutdown, they should still come back up when power is restored to the UPS or 15 minutes after power is restored to the PDU. This means we can easly reboot all the servers remotely by powering them on and off at the mains, that said I don't like doing this as its not good for servers and defies the whole point of a graceful shutdown. We have also had a dedicated 20 AMP way installed into the server room that is used for powering the UPS's, this should ensure that another device in the building will not knock out our server room!

To ensure we are kept upto date with what is happening during a power failure we now SMS critical errors out of hours and also emailed using an external mail provider (bear in mind there is no point using your internal SMTP server to let you know that the power has been restored if the UPS's have shut it down).

We have spent lots of time researching and implementing this new solution, to be honest we don't have many power problems in our office and it will probably not happen again for another 10 years. But we have learn lots and I personally have enjoyed making our server room as resilient as possible with a limited budget. The other way to look at this is if we hadn't spent the time looking at our backup power solution now then maybe it would have caused us more problems in the future, what I mean by this is that we were lucky on that fateful Sunday morning, if the fuse hadn't of done its job there could have been a fire, the servers were OK, but an ungraceful shutdown could have corrupted data and caused us days of downtime in recovering our systems. End of the day lessons have been learnt and the world is now a better place for our increased in knowledge in the area.

Are you sure that your server room is fully covered? Give us a ring on 08451221240 for a free server room assessment.

Correct use of ADSL faceplace splitters and extensions

Many of you will quite often double up you phone line / fax with your Internet connection. Previously we have used ADSL splitters that plug into the existing standard BT socket. More recently I have been getting a ADSL faceplate to swap out the lower part of the BT NTE5 socket, these are great because they are less likely to get snagged / break and a far neater solution.

 The beauty of using one of these faceplates is that you can run extensions from it that already have a filtered connection. Therefore if you connect pins 2 & 5 on the 6 way IDC block (there are some 3 way versions out there, but again the pins are the same) to your extension you will get dial tone without the worries of your internal cabling causing you issues with your ADSL connection.

Its also worth nothing that you can get a unfiltered connection perfect for your ADSL modem by connecting pins A & B. This is good if you would like to put your router in a different location to your master socket and still get the benefits of a central filter.

You could make it a nice neat solution by terminating the unfiltered connection on a RJ11 socket. Also that way it will deter someone from putting in standard telephone and causing disruption to your Internet connection.

We quite often use a CAT5 cable to get the point where we need it (for example where the FAX is located), a nice neat trick is to cut the end off a RJ45 cable and crimp the blue and blue/white pair into pins 2 & 5, this should be the middle pair on a properly made cable. You can then plug a RJ11 directly into the CAT5 socket.

Exchange 2010 backup fails with the error "0xe0000380 - Backup Exec attempted to back up an Exchange database according to the job settings. The database was not found in the Database Availability Group (DAG)" even when there is no Database Availability Group (DAG) setup

Problem
We had a recent issue where Backup Exec 2010 just stopped working, it wouldn't backup anything and gave the error;

Exchange 2010 backup fails with the error "0xe0000380 - Backup Exec attempted to back up an Exchange database according to the job settings. The database was not found in the Database Availability Group (DAG)."

It was odd because even though it was a Exchange error, none of the job would run, not even if I changed the priorities of the selction list.

Cause
This failure may occur if the Backup Exec Remote Agent Service on the Exchange Server(s) and Backup Exec Server is NOT using the Local System Account (LSA) as the logon account.
This issue may also occur if the Backup Exec Logon Account being used to access the Exchange server does not have the required permissions assigned to it.

It seems bizzare for this problem to occur of its own accord, but it did!!

Solution

1. Go to the Services panel on the Exchange Server(s) and Backup Exec Server, go to the properties of the "Backup Exec Remote Agent for Windows Systems" service.
2. Select the "Log On" tab and change the logon method to "Local System Account".
3. Restart the service after applying the change.

Aggregated Lookups in SSRS

SSRS 2008 R2 has a nice function to be able to lookup another dataset. Using Lookupset you can return a list of entries in another dataset that match your specified values. The structure of the function is as follows:

Lookupset([Source Expression], [Destination Expression], [Result Expression(Value to Retrieve)], [Dataset])

As an example, this passes the customer address ID from the current Dataset to match the Address ID in the AddressesDataset and Returns the matching postcode.

 Lookupset(Fields!CustomerAddressID.Value, Fields!AddressID.Value, Fields!Postcode.Value, "AddressesDataset")

This is all well and good, but what if there are multiple matching entries that you want to aggregate? In my case - Sum. There isn't a function out of the box in SSRS that I'm aware of, but I found this very handy little piece of code. (This could be easily modified to aggregate in some other way should you wish)

Function SumLookup(ByVal items As Object()) As Decimal
If items Is Nothing Then
Return Nothing
End If
Dim suma As Decimal = New Decimal()
suma = 0
For Each item As Object In items
suma += Convert.ToDecimal(item)
Next
Return suma
End Function

Drop this into the 'Code' area and then simply call it in your expression and pass the lookupset to it. The resulting value will be the sum of the called entries

Code.SumLookup(Lookupset([Source Expression], [Destination Expression], [Result Expression(Value to Retrieve)], [Dataset]))

 

As an example, this matches the client again but returns a sum of that clients billed invoices:

Code.SumLookup(Lookupset(Fields!ID.Value, Fields!CustomerID.Value, Fields!Billed.Value, "InvoicesDataset"))

KB2667402 Causing Remote Desktop not to work

I have had a recent (I looked at it about a month ago, then revisited it again today and have have come up with same outcome) problem where the Microsoft update KB2667402 caused some servers to stop working in terms of RDP connections! Nothing shows in the event log and the user error is essentially the same as the server been down.

Having spent hours trying to fix this the only workaround I have been able to find is to un-install the update and decline it in WSUS so that it doesn't get installed again. I am sort of OK with this as its behind a firewall and RDP is not Internet facing.

I have tried everything including;

1. Un-installing KB2667402 and installing the new updated Microsoft KB2667402 v2 patch - Didn't work!
2. Un-install the KB2621440 and KB2667402 then I installed again the KB2621440 restarted the server and I installed the KB2667402 - Didn't work!
3. Un-installing KB2667402 and installing the new updated Microsoft KB2667402 v2 patch and then replace the rdpcorekmts.dll from a working machine - Didn't work!

I am always a big fan of Microsoft but I feel that from looking at the forums they have still yet to address this issue, months later!

SharePoint - Out of the Box KPI Functionality

I've been playing about recently with the KPI functionality within SharePoint 2010:

• I set myself up with a Status List
• Created a few performance indicators
• Loaded the KPI Status List webpart

Then I encountered a problem - I needed to filter the list of KPIs by the current user. Simple right? No. Every other list you can filter by the current user but not the Status List. Even if you apply the filter to the view, the filter doesn't apply and there doesn't seem to a way to connect the webpart to a current user filter either.

I could use a standard content query webpart but then I don't get the nice indicators (I don't even see a way to display the actual key value)

So unless anyone has any other ideas I have two options

1. Create my own custom webpart
2. (The easier option) Use SQL Reporting Services (SSRS) to build the users KPI list and show that on the page instead.

Very disappointing!

Using FreePBX with Custom Contexts, Account Codes (Asternic) & Music On Hold

We have had a tricky problem recently that meant that I had to get to grips with Asterisks configuration files, usually the GUI handles pretty much everything.

The problem was that we were using custom context to direct certain extension to certain routes, which works brilliantly! We were also using account codes for extensions for outbound call accounting, which also worked great! We then needed different MOH for different outbound routes, unfortunately for extensions that were using account codes this broke the custom MOH function within a route and it always played the default MOH. This wasn't acceptable as the company we were sharing the PBX with for simplicity have had customised MOH created to sell their services.

The solution was to modify the extensions_custom_asternic_outbound_freepbx.conf file so it has the following entry;

[queuedial]
; this piece of dialplan is just a calling hook into the [qlog-queuedial] conte$
; outbound dialing - replace as needed - just fill in the same variables.
exten => _X.,1,Set(QDIALER_QUEUE=${CDR(accountcode)})
exten => _X.,n,Set(QDIALER_AGENT=${AMPUSERCIDNAME})
exten => _X.,n,Set(QDIALER_CHANNEL=${OUT_${DIAL_TRUNK}}/${EXTEN})
exten => _X.,n,Set(QueueName=${QDIALER_QUEUE})
exten => _X.,n,MixMonitor(${QDIALER_QUEUE}-${UNIQUEID}.wav,b,/usr/local/parselo$
exten => _X.,n,SetMusicOnHold(FusionMOH)
exten => _X.,n,Goto(qlog-queuedial,${EXTEN},1)
This then forces any outbound calls that utilise the FreePBX custom extensions file and thus the extensions_custom_asternic_outbound_freepbx.conf as it is an #include in this file to use the MOH that you specify and not the default.

Word Field Codes - SET, REF and SEQ

Problem

One of our Clients recently had a Word document within which they wanted some headings to be conditional based upon data from their Accounts/Contact Management Solution (CMS).

As an example these were the headings they wanted:

 

1.    Red- Fixed Heading (Always 1)

2.    Green – Conditional Heading

e.g. {IF { MERGE FIELD FROM CMS}  = "1" "Green"  "—No Heading--"  \* MERGEFORMAT}

3.    Black – Conditional Heading

e.g. {IF { MERGE FIELD FROM CMS }  = "1" "Black"  "—No Heading--"  \* MERGEFORMAT}

4.    Blue - Fixed Heading

If Items 2 and 3 aren’t in place Blue should be numbered 2.

Resolution

The first thing I tried was the SEQ field code, but what I found was the SEQ field behaved strangely within the IF Statement (Probably due to the timings of loading the data).

I did however find a solution using SET and REF:

At the beginning of the document I created a SET field

{SET numb 0} – To create a variable of 0

Within the document I then created the headings as follows:

{SET numb {=numb + 1}} {Ref numb}Red

{IF { MERGE FIELD FROM CMS}  = "1" “{SET numb {=numb + 1}} {Ref numb} Green” “”}

{IF { MERGE FIELD FROM CMS}  = "1" “{SET numb {=numb + 1}} {Ref numb} Black” “”}

{SET numb {=numb + 1}} {Ref numb}Blue

If you have any queries regarding SET, REF, SEQ, IF or any other field codes, ask us using the comments field below.

SharePoint Data and SSRS Reports

Problem

I had a number of reports configured in SSRS to output data from our SharePoint server. They worked fine but with the following issues.

1. When browsing the report if the user navigated away from the page and then clicked the back button all the SharePoint data within the report would display an error
2. If the user exported the report to Excel all the SharePoint data would be replaced by an error.

Solution

The reports in question all had something in common; none of them had a table or matrix within the report to display the SharePoint Dataset (via SOAP query). In each case I was using the data for calculations within tables linked to other datasets (SQL connections).

As soon as I added a hidden table to directly display the SharePoint data the problem went away.

It would seem therefore that unlike SQL connections which 'just work', SOAP datasets are only loaded when the report is first displayed, unless you have a table or matrix that directly references it. Hence why it wasn't loaded the data on the page back or the Excel Export.

Lesson learned.


My Setup: Visual Studio 2010 publishing reports to SQL Server Reporting Services 2008 R2.

SharePoint and Business Data Columns

Problem

I've been struggling for a while copying data from one SharePoint List to another where one of the fields links to Business Data Connectivity (BCS) data. The copy always works with no errors, but the recipient BCS field remained blank.

Solution

If you tell SharePoint Designer (SPD) to populate the BCS data column in List B from the BCS data column in List B it simply won't work. (It does actually copy a name in the field but the link to the BCS data is not actually created). This is because it also needs to have an ID entered in the [yourBCSdataname]_id field.

Annoyingly SPD will let you read from this id field but it won't let you write to it.

My workaround therefore was to write the id field from List A into a temporary field in List B. To make things a bit easier for me I also copied the display name of the BCS item to a temporary field in List B. Upon item creation in List B I then fired a visual studio designed workflow to copy the data from the temporary field into the id field in List B. The code was relatively simple:

SPListItem item = workflowProperties.Item;
item["MyBCSData_ID"] = item["tempid"].ToString();
item["MyBCSDataField"] = item["tempname"].ToString();
item.Update();

Note: If you have any additional BCS fields displayed these won't automatically be populated. You will need to refresh the BCS data for this to happen. There is code out there to do that, but it wasn't an issue for me I was purely concerned with getting the link created on that one field.

See my post back on the original Microsoft Forum HERE

Internet high availability, dual connections. What would you do if you lost the internet for days?

At Fusion we take Internet connectivity very seriously, we recently had a clients internet connection develop a fault. Once we eventually got it logged as a fault with BT via our service provider (Andrews & Arnold) the earliest appointment for an engineer was two days later, this would mean a transport company who's business is totally reliant on the internet crippled for days.

We always react to these situations fast and quickly, within a few hours we implemented our FusionNet Firewall along with Andrews & Arnold's backup 3G mobile data service to give the whole company access to the internet using the Three Mobile Network. Whilst the connection wasn't the speeds they had become accustomed to, it did mean that they were once again connected to the outside world and able to do business as usual until the BT fault was rectified.

Faults on lines happen every day in varied levels of severity and could easily happen to you! We can solve this problem by implementing a FusionNet firewall device and by having two internet connections coming into the building from two different supplier; one using the standard BT Wholesale product that the majority of ISP's will resell and one connection using O2 Wholesale product. Both BT and O2 have their own equipment in the exchange which means that barring someone chopping the copper cable coming into your premises, both lines will never be down at the same time. Should you want even more peace of mind we can also install the 3G data dongle as an additional backup connectivity method. We also proactivly monitor your connections to ensure that if any line does go down then we get the fault recified as soon as possible, afterall if you are using the backup line and that also develops a fault then you are once again without internet connectivity.

We practise what we preach and at Fusion internet connectivity is the most important part of our business. Without it we cannot receive your calls (we use a VOIP telephone system), we cannot connect to your computers to give you support and we would be unable to pickup your email requests. We effectively wouldn't be able to do business! Therefore we have a O2 connection provided by Andrews & Arnold, we have a BT connection provided by IDNET, and a super fast 100 meg pipe to Virgin. For the more technical people amongst you we also use Andrews & Arnolds L2TP fallback service so that we can still use any of our allocated IP addresses using any service provider.

Is your business at risk, why wait to be in a situation where you don't have internet access for days? If so call us today for a free no obligation chat on 08451221240

Skype & Voice Over IP

So you can now contact Fusion using Skype, we have a Asterisk based sophisticated VOIP (Voice Over Internet Protocol) telephone system. For many years Skype has used it own proprietary protocols which has meant very little integration with other systems. Now they provide SIP channels via the product Skype connect, imagine the power of someone looking at your website clicking on your call me Skype icon and the call been answered by your receptionist using her traditional handset or even your digital receptionist using the PBX menu system. Once the call is in the telephone system its treated just like a normal call.

Not only can people call you for free, you can also call other Skype users and you can also use Skype for your outbound calls to the standard telephone network. Skype even give you some nifty reports so you can see your call spend.

Call us via Skype

Welcome to our blog site

This is the first post of many. We quite often work on projects that we would like to document and let other IT users / professionals know all about it, after all we get a lot from the community, why should it be one way? If we are the artists then this blog is to be our canvas. Welcome to the Fusion blog!