Call me naïve, but I’m constantly surprised at how little most organisations seem to know about their own information. Like how much they’ve got, where it is, what it is…. But that’s good news for us, as we’re often asked to carry out surveys or inventories of electronic and/or paper documents and data, usually as part of a wider information management piece, and they always provide a fascinating insight (for us as well as the client!) into each organisation’s business and how it’s carried out.
There are many reasons why you might want to carry out an inventory, for example:
• to identify vital business information (especially records)
• to support information governance, eg DPA, FOI or RUPSI requirements
• to support the migration of existing documents, records or data into a new environment
• to investigate possibilities for system and process integration
• to support the easy production of an Information Asset Register
• to inform file plan or taxonomy development
• to inform the development of document templates
• to plan for future storage requirements.
I’ve just completed an inventory for an organisation of about 700 people, and almost all of the above apply, so the inventory is pretty extensive and includes over 80 questions for each ‘collection’. The main difficulty has been identifying just what a ‘collection’ is in this context, as there are business documents such as you get in every organisation, but also extensive data sets, databases and publications which may all have a relationship to each other.
Our approach is to identify the teams (that in itself can be a challenge!), and create a profile of the team in terms of their function, but also in terms of the kinds of documents and records we can see that they use by analysis of file shares. This gives us a very preliminary view of the potential scope of each team’s content. Interviews with the teams will then reveal ‘collections’, ie coherent bodies of content used for specific business purposes. Sometimes these will be distinguished just by the business purpose, but sometimes format or location will also be a factor.
When the inventory has a relatively straightfoward and focussed purpose, it is very useful to send out the questions beforehand, but you have to be sure of your clients and their content before you do that. If I sent out my 80 questions for the complex inventory, I think people would run! So interviews are vital, but quite often people don’t know all the answers themselves, and you need to talk to other members of the team to get the whole picture.
We use InfoPath forms to record the information and create tailored reports so it’s easy to find out how many of this and what kind of that, otherwise you can spend hours analysing each questionnaire. The questionnaires and profiles are then all stored on a SharePoint site that is open to all to look at and query (but updating of the information needs to be carefully controlled, obviously).
Carrying out an inventory can take anything from 2 weeks to 6 months depending on exactly why you’re doing it, how complex the content is, and how many people you have working on it. Another contributory factor is how well people know their own information (and no-one is going to be able to answer the question ‘how many spreadsheets do you have?’), so the more you can do for yourselves by using tools to analyse file stores, for example, the better. We’ve developed tools to count numbers of documents and analyse formats, and that helps a lot. And when calculating how long it will take, don’t forget to add in the time it takes to set up the interviews, and to set them up again when people forget or cancel.
As well as the documentary evidence (ie the profiles and questionnaires), we always provide a report which highlights the main findings of the inventory, and there’s always something in it which surprises the client, whether it’s the sheer number of documents per person, or the number of Excel spreadsheets across the organisation (an important consideration if you’re thinking of migrating them to SharePoint, as it really doesn’t like macros at all), or the number of different repositories, or the fact that so many key assets are stored by a third party (fine if they’re archived material, but less good if they’re current IP). Which goes to show that inventories are extremely useful things.


