Key Roatation Register

[Soldier_Why]

I am having a complete mong moment and hopefully some of our more intelligent members can help me out. I have been tasked to produce a 'key rotation register' for the various safes and keeps that we have in my building. Each lock has 3 keys (1 used and 2 spare) that we should have been rotating every six months.

I am sat here staring at the PC and for some reason have absolutely no fecking clue as to how to layout such a thing. Everytime I start to create a format it just looks completely wrong, I am sure it is relatively simple but I am obviously thicker than I previously thought.

Can anyone shed any light for this poor bemused shiney arrse?

 

[skintboymike]

I've got an old Excel spreadsheet used for key rotations - if you pm me your email addy I can send it to you. It might not be exactly what you had in mind, but it might spur the mind a bit.

 

[Soldier_Why]

PM sent mike, thanks.

 

[skintboymike]

PM and email sent.

 

[Soldier_Why]

Received your e-mail mike but cannot open the attachment as it has been created in a newer version of Excel.

I am using Excel 2002 on any Army machine, any chance you can save as an earlier version on yours?

Many, many thanks.

 

[skintboymike]

Sent again mate, check emails!

 

[Soldier_Why]

Sent again mate, check emails!

Received with my utmost gratitude.

Job done mate, many thanks.

 

[Sheepay]

Less time on COD and that key register could be a gleaming template.

 

[subbsonic]

Idon't know what the fuss is. The format for the key rotation register is in Part 3 of BAOR supplements to MAS.

 

[skintboymike]

Less time on COD and that key register could be a gleaming template.

And we wouldn't want that now, would we?

 

[Howayman]

Idon't know what the fuss is. The format for the key rotation register is in Part 3 of BAOR supplements to MAS.

Sub, what key setting are you on? All of the above would appear to be gibberish.

 

[Op_Int_and_Spy]

if you have an adequate security key register a separate one for rotation should not be necessary..........

 

[Soldier_Why]

if you have an adequate security key register a separate one for rotation should not be necessary..........

Oh FFS, what's one of them? Best I dig out the MAS on Monday.

 

[Op_Int_and_Spy]

Oh FFS, what's one of them? Best I dig out the MAS on Monday.

If you have security keys and they're not in a register then you could have issues if one goes missing!

 

[HIGHLANDER_SPY]

Sub as usual was quite correct, although for one growing so old, he incorrectly gave the Wrong Supplement, as Security of Keys and Combinations was covered in both BAOR Supplement No 7 to MAS Volume 1, Chapter 7, (Security of Information) and UKLFSI No 1. However, if he had bothered to look, there was also a perfectly good Annex to Chapter 7 which showed a Key Register template and explained how to use it, including recommendations for the frequent rotation of security keys.

Sorry for outing you Sub, but remember, I have been out longer than you !

 

[bluntslane]

Oh FFS, what's one of them? Best I dig out the MAS on Monday.

Don't they do annual security inspections anymore?

 

[rebel_with_a_cause]

Sub as usual was quite correct, although for one growing so old, he incorrectly gave the Wrong Supplement, as Security of Keys and Combinations was covered in both BAOR Supplement No 7 to MAS Volume 1, Chapter 7, (Security of Information) and UKLFSI No 1. However, if he had bothered to look, there was also a perfectly good Annex to Chapter 7 which showed a Key Register template and explained how to use it, including recommendations for the frequent rotation of security keys.

Sorry for outing you Sub, but remember, I have been out longer than you !

MAS, BAOR what are these things you speak of, something from "back in the day"?

 

[Minnesota_Viking]

Don't they do annual security inspections anymore?

They never did. Now they have what's called a security risk management process, and if you keep stumm you'll hardly ever see a green beret darken your doorstep.

 

[CRmeansCeilingReached]

They never did. Now they have what's called a security risk management process, and if you keep stumm you'll hardly ever see a green beret darken your doorstep.

... but will be suitably aghast when they turn up to investigate your loss of 19 x laptops and the next Wikileaks instalment.

 

[western]

... but will be suitably aghast when they turn up to investigate your loss of 19 x laptops and the next Wikileaks instalment.

Or laughing their tits off when it is discovered that they were issued without encryption but passed the last five inspections.