Solved

Month End Reporting

Posted on 2014-01-15
11
307 Views
Last Modified: 2014-02-03
Hi Experts,

I know that most of us do Month End reports on our various Infrastructures and there are many tool out there that do it some good some not so good.  Im looking for something that will give me an in depth report on the status of some of the critical systems in an infrastructure (Tags above) possibly a PS script that will go through my infrastructure and compile the information in html or something.

I know im looking for a quick fix, but Month end reporting is taking up way too much of my time as I have to scour though various tools and put it into a report.

Thanks.
0
Comment
Question by:damejen
  • 3
  • 2
  • 2
  • +1
11 Comments
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
Comment Utility
Please have a look at LANSweeper http://www.lansweeper.com/  I used it extensively in my last place of work.  It relies on WMI (Microsoft) but it certainly was able to capture as much info as I needed at the time to report on.

Certainly work a look.
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
If you want a quick fix, you need to use the month end reporting of your financial system (QuickBooks, Simply Accounting or whatever).

If you want a proper and long term fix, create a report format with Actual, Budget and Last Year for operations and a comparative Balance Sheet. Export data from your accounting system into worksheets and then make formulas to extract data from the worksheets into the two report sheets (Operations and Balance Sheet).

... Thinkpads_User
0
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
Comment Utility
Is this a financial or infrastructure reporting question?  
Apologies if I've confused anyone, I understood it to be the latter.

Rob
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
I made the assumption that "Month End Report" meant a report to management, and then by extension, would be financial in nature.

@damejen - Please clarify as I have not seen Month End infrastructure reporting before.

.... Thinkpads_User
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 24

Expert Comment

by:diverseit
Comment Utility
Hi damejen,

I'm with @thinkpads_user, I'd like to know what you mean by "Month End Reporting" too...it's too vague.

We use a combo of RMMs consolidated into one report. But that is complicated. I think http://www.spiceworks.com/network-management/ would give you a good starting point and its free. You could have a report completed in a few hours after downloading, scanning and deploying it.
0
 

Author Comment

by:damejen
Comment Utility
Hi Thinkpads_User & diverseit.

My apologies, I should have been clearer in my question. Im currently a Systems Administrator and every month at the end of the month have to collate and get information on the various systems in our Server Infrastructure, Server 2008 R2, ESxi 5.1, Exchange 2007 e.c.t

I manually have to go through each system and obtain the information. I use SolarWinds and its actually quite good at obtaining allot of this information. What I was really after was something like a PS script that can be customized to my infrastructure and obtain all the information im looking for and spit it out into a work doc.
0
 
LVL 24

Accepted Solution

by:
diverseit earned 500 total points
Comment Utility
That is what Spiceworks will do...look into the Inventory section. It will grab HDD, size/changes, RAM utilization, all HW specs (including service tags & warranty info), install software w/versions, etc. and put it into PDF or Excel file.

As far as PS scripts - I don't have any that would do that. If you are specifically locked in to using a PS script maybe @thinkpads_user has something.
0
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
Comment Utility
LANSweeper will also do the same but I suspect Spiceworks is a better product? diverseit?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now