SnTT - Rooms and Resources Accidentally Delete a Resource and the Reservations

Last week I gave a session where I outlined a bunch of things I would like to see in the new Rooms and Resources database template should it get updated.

Yes some things were just more defined views, but other things that would make it more useful to admins, and users, were also included.

Well yesterday I learned the hard way about some things I knew, but I guess had not quite gotten to fix yet. Let me explain.

One of my clients has some very full RnR databases, 1 per region. Sometimes, against my preference, names or very similar names, are used in different places.

Tasked with clearing some old rooms, I set out to do just that and get on with my day.

And, of course, as you may have guessed, I deleted an active room.

Very active room.

400 reservations active.

As I saw when the pop up asked me if I wanted to notify people. I said no to that, knowing I can fix this. Well a few hours later, here is what really happened.

Oh.Yes.I.Did.

Domino problems are caused by admins, truth (except for developer agents that run amok).

I say, no problem, go to trash and undelete it. No Trash View in this R9 template. Note to HCL, please add one. Go into developer mode figuring it would be in the hidden view.

No

Call client developer and ask what they think, SOL. Soft deletion was not turned on.

Damn. Thought we had enabled it after last issue, but maybe the template got written over in an update or a restore and maybe we had only set soft deletions in the database itself and not the template.

In any event, I was blocked this route.

Call restore team, can you provide me with a backup from the prior 24-48 hours ASAP?
Yes, no problem they said.

Great, restore completes and I go to try to get back the data and...it shows me what I see now, not what I should have seen for a day ago.

AGH!

Call restore team, ask how it is possible. Well replication was on, ok, try again, turn it off this time.

And get notification, go open it up, same problem!

Well now I am confused. Got the team together to figure it out, and it seems they do incremental backup sand logs.

I said I don't want logs just data.

And 3rd time lucky, I open it up and it is the old data. Perfect, I start to copy a doc to test that pasting it back in will work.

BAH! No dice, this database doe snot allow pasting of documents.

WHAT!?!?!?!?!?!

Call back the developer, ask how I, as the admin, can not do this. Well, she knew why and where to look to fix it. And now I will let you know because someone out there will read this after pulling their hair out.

Open the database in the Designer client and go to the views section.

Find the view you need to paste into, you will need 2 of them.
The first is the resources view itself because you need to copy back the deleted resource.
The second is the view of Reservations, by Resource so you can paste back all of the reservations you killed accidentally.

Once you have the view open, locate the Querypaste section as shown in the graphic below and REM out all of the code there and save it.

Once you do this and reopen the database you should be able to paste everything back in.

Then run a Fixup and Updall to get everything cleaned up and reindexed and then test making a reservation that honors used and open times.

You learn something new every day, even after all these years.

EDIT: Adrian asked me on twitter about Adminp and Busytime. I forgot to discuss it, so here is what we did and what you should check.

Adminp at the customer is set to run on a set schedule, so it did not worry me, but you should go into the database and clear the delete request otherwise you will lose the setting in the names.nsf for the resource.

Busytime, I did not rebuild it because my tests showed it was working. Presumably because the dates/times had been in the database already and did not update but if you run into problems, you should follow the technote and clear the old busytime and let a new one start.

How an Admin Could Sell Domino to Management

Originally Found on Gavin Bollard's Blog http://dominogavin.blogspot.com

This post is based on conversations at The View Admin 2011 Bar Camp night in which I extolled how Admins are responsible for their own downfall, albeit unknowingly in some cases.

There are many out there who do great work, maintain infrastructures others would die for and seem to get anything they need/want or ask for, yet others do not have any of this. Why? I had been thinking about this for some time and when the opportunity came up at the Bar Camp it provided this post.

One example came from someone who had migrated users to Notes from Outlook and another who had upgraded from R6/7 to R8.5. Spell check was not turned on by default and the users complained. Now there are a few ways to deal with this but I put it on the Admin(we talked after and all is okay) because my view is shame on you! Policies exist for a reason, use them! When you install clients, didn't you pre-configure them for the PC support teams builds? If you would use it or set it, so would your users, so why make them do all the work? A little bit of time upfront saves help desk calls, irate employees, delays, unprofessional emails and a host of other items. So yes, we as Admins should take the blame because we don't know what we could be doing. Ignorance? Lack of training? Laziness? Lack of Resources? All the above? Go set the default policies for mail clients NOW, save yourself, and your help desk time and grief.

In my DDM (Domino Domain monitoring, it is the DDM.nsf) session I pointed out that there is a built-in dashboard, it is FREE, as in, um, zero cost, 100% FREE. This dashboard is what will make or break you annual review! You do want to get a raise correct? Well how does your boss know all the things you have been working on that NO ONE EVER KNOWS ABOUT to keep Domino and your servers running smoothly. This dashboard can be viewed by date, severity, server and even delegation. Yes you can delegate items to your staff. Think about how you look when you have server documented details for your review!

Now this will not save you from Microsoft happy CIOs or Google VP of Marketing but think about it this way. What if at every weekly/monthly meeting you had this dashboard for management(I know they can see it at anytime, but you know management, they get sidetracked easily) to get a gauge of what is truly happening in your environment? Get a screen shot of the server being up for 100+ days at a time. Ask everyone else in IT to provide a similar screen shot. Cheap and gimmicky? Yes but you don't want to hear from the new exec how Domino breaks down all the time, especially when it doesn't.

But if only you know this information, no one else will champion your cause. And this is the point.

Keeping your IBM infrastructure, hardware, software or anything can only be done when you provide management with reasons and examples for what you have and why it is good, working and forward thinking. Here is a hint, technology is not what is important to management. Quiet nights sleep, no emergency calls or screaming from the C level about something being down. And they like new shiny things to play with too. INSTALL TRAVELER! It also is free and you have no reason to NOT use it. Security perhaps?

Someone said they are not allowed to use iNotes or Webadmin because Security said they need 2 types of authentication. Get on Domino 8.5.2 and you will see that if you use Certificate Authority and ID Vault there are 2 separate transactions, maybe more involved. If you don't know, ask someone, search Google. But never, I mean NEVER let Security people push you around or Firewall people or OS or hardware or anyone. You are a Domino Admin, you know or deal with more than any one of these people ever will and they should bring information to YOU not have you prove it to THEM!  You are a swiss army knife they are just one solitary tool, use it or lose it.

If you are not doing these basic things you will lose control of your environment, to the Cloud or some other vendor.

If you run apps, get transaction details by day/week/month/quarter and get them into the executives hands. Make a simple view in the app if possible JUST FOR EXECS. Hint, ask the developers to help. If you run an app that every sale MUST get posted, send a report to the VP of Sales. They will love you for it because the sales people lie daily about leads and deals, but here you have details. Nothing signed, nothing entered, you know and now so do they. Make others accountable so they back you up when you need it. Think outside the cubicle!

If you run mail, point out mean time between failures, if any, and the number of messages sent hourly, daily, weekly, etc.. and the down time and what that equates to in emails which also equates to money. IBM was not wasting money on buying Cognos, management wants analytics and the more you provide the better for you.

Why? Because when the new CIO walks in and says where's my Sharepoint or Outlook, YOUR manager and others will point them to all of the details you have been sending, showing and backing up the premise that a whim does not make money. A well maintained infrastructure makes money or at break even doesn't lose any money because of down times. Which is just as important.

Talk about Uptime whenever possible. Sure we all patch servers and need down times but if you can show 0% downtime aside from planned schedule outages that goes a long way.

None of this may make a difference in some cases, but if you are not out there getting the basics to the people that will help you when you need it, then what are you doing with your job? Set the bar high, make it so high no one could possibly get into your infrastructure to knock out Domino or an i series or Linux or whatever is that important to you.

You the admin can do this, developers have a future in other languages but as an admin you may not get retrained or an opportunity to learn and experience more so make the most of it.

PS - Websphere IS IMPORTANT to your future, take the time, learn it or at least get familiar with administering it because Sametime, Connections, Forms, Quickr already are there.

Domino Admins Know more than

Almost any other Admins on Earth.

Why? Because we have to and we do it all while ensuring our servers are built to withstand whatever you customers can throw at it. And do we ever get thanked for it? Training for it? Respected at salary review time?

So pity those pathetic Microsoft Exchange admins that just need to understand this year's version of AD and other peculiarities of security.

Your average Domino Administrator may know any, all or most of these items:

1. Java, Oracle, SAP, SQL, DB2, Websphere/WAS (they will soon if not)
2. Telecom - Everything from running cables to QoS and even configuring your Cisco routers and wireless gateways.
3. BES, Good and god knows how many devices they need to support
4. LDAP, SSL, SSO, POP3, IMAP, MAPI, SMTP, H.323, T.120
5. TCP/IP, IPX(yes, still), Netbios, Host tables and Firewalls
6. Modems, Wi-Fi, Bluetooth
7. DOS, OS/2, Novell, Windows, AIX, OS/400, Mac, Linux, Mainframe, maybe even Cobol
8. Lotus products, Microsoft Products, Google products, Novell products, Social media apps, Firefox, Safari, Opera
9. Updated: Anti-virus and anti-spam products, filtering/rules, blacklisting, whitelisting, journaling, archiving, Clustering, DNS, Backups/restores, Policies (user/group/domain)
   
10. So much more from Business Continuity/Disaster Planning to paper reduction and power consumption and how to reduce your licensing costs with Microsoft.
11. Some even develop their own applications for your company

So the next time you think you know what your admins do, remember they make your world better every day.

See you in Chicago at MWLUG.