Skip to main content

Kevin Hughes

Go Search
Home
Biography
Microsoft Profile
  

 User Groups

  Kansas City .NET User Group
  Heartland User Group Kansas City
  HUGKC SharePoint SIG

 ‭(Hidden)‬ Send Feedback

The life and times of Kevin Hughes - MCT, SharePoint Architect, SQL DBA, Systems Admin, Master Mason, philosopher, and low-budget philanthropist.
Review: Quest Site Administrator Reports OnDemand

The new Quest Site Administrator Reports OnDemand that was released yesterday is pretty.

You get it at http://www.quest.com/reportsforsharepoint

Description from Quest's website:

"This new free web hosted tool allows you unlimited core Site reporting as well as a portal to content within SharePointforAll. You can run a site storage usage report on any SharePoint 2007 or 2010 site that you have access to. This tool is currently in Beta so visuals may change from time to time and updates are available immediately as soon as we update the app.

Site Administrator Reports OnDemand is hosted in Microsoft's new Cloud platfrom Azure and leverages Silverlight for its visuals."

 

You get a single page report with the following data:

  • Site Metrics – summary of the number of sub-sites, total lists, document libraries, doc size, and a total content storage size.
  • Site Sizes – the sizes of individual sites in a collection
  • Document Sizes – largest files
  • Document Type Sizes – storage usage by document type
  • Storage Space Distribution – Content vs. versioning

The displays can be changed from data to bar or pie charts.

I believe most of that data can already be seen by site collection administrators, but this is a more concise summary that takes the data already available and puts it into a pretty graphic format.

 

Potential points to consider…

It is available for free to be used by anyone that has local administrator rights on their PC and full control over a site collection/site.

It requires no installation on a server so we have zero control or visibility into who runs them.

The query runs for a long time and may impact performance – especially if more than one is being run at the same time. Report on an average site collection took 66 minutes to generate (6.38 GB)

The reports are stored on the local machine Silverlight storage cache so are not available to anyone else and there seems no way to export. However, the good thing there is that once the report is run, the cached report is available until the admin clicks "Update" to rerun the query.

Lastly, since it uses Quest's website to do the analysis you expose as much data as your credentials allow in SharePoint – even behind firewalls since you've already made the connection. While I am not concerned about Quest itself, it does raise concerns that must be addressed to management and security officers about exposure of internal data to an outside party. And I've seen nothing to which I can refer them on Quest's website. It may be there, but it escapes my search at the moment.

 

I'm still testing to see if there is impact in large deployments with distributed site collection management. Until then, if anyone has an analysis I would be happy to know what you found.

Play nice and Share. Get the Point?

 

 

 

Building Roads with SharePoint

In any effective team a variety of people with different, but complementary, skills and experience come together to achieve a common goal. There may be overlap of skills and experience, but each person on a team will bring some strength that the other team members do not have. The team members may rotate roles as needed, but should be allowed to focus on their strengths which may preclude some members from fulfilling some team roles either by personal choice or a management decision. All should use their strengths to support the team effort – participating in idea generation, problem solving, and decision-making. They should respect and trust one another's skills and abilities, but also respect each other as people. Each should take actions and perform work that is necessary to reach team goals.

The SharePoint environment is best deployed and managed in an enterprise through the use of an effective team. In smaller deployments, one individual may take on multiple roles, but usually will be less effective in some than others – again they will have strengths as well as weaknesses. My experience leads me to believe that in an effective team dedicated to deploying and managing an enterprise SharePoint environment there are five distinct roles of an effective SharePoint team. These are Architect, Developer, Administrator, Site Designer and Manager.

This is not to say you need five individual team members, as some persons may be able to fill multiple roles, or your environment may be large enough to need multiple persons filling some of the roles. Likely roles to often cross over in a single individual team member are Developer & Site Designer, Architect & Developer, Architect & Site Designer, Architect & Administrator. Note that I didn't mention that the Manager should be one of the cross-over roles. I believe that the other four roles are often too focused on the technical aspects of the environment to be effective at managing the team. Of course there are exceptions. Also, it may appear from the example above, that the Architect role may be considered superfluous if it can cross over to most any other role. This all depends on the strengths of your team members, the size of your environment, and the goals of the team. This type of team, as any Information Technology team, is most effective if there are individuals dedicated to the separate roles, although, again, roles may shift or rotate as needed.

It's easy enough to describe these roles using technical terms, discussing programming languages, operating systems, computer hardware & software specifications, network diagrams, etc., but that is only informative to those technical enough to understand what all those things are, how they function and how they work together. Since I currently work in a firm dedicated to designing and building bridges, interstates, airports, stadiums and conference buildings, I thought I would use analogies with a civil engineering spin to describe the roles in an effective SharePoint team.

Architect -

A SharePoint Architect is an Infrastructure Architect and is very much like an architect for a highway interchange or interstate system. This is a specialist in designing transportation infrastructure to allow the most people to get where they need to go as quickly as possible as safely as possible.  He needs knowledge both wide and deep regarding the capabilities of all the associated technologies, materials and skills that go into building this infrastructure. He has to know what materials work together to create sturdy, enduring surfaces. He must know how much load they can bear at what weather conditions over how much time in order to use the correct materials for flat roads vs. overpasses vs. steep grades, in desert heat or blizzard. He must know how to take information about population distribution and growth trends and turn that into traffic patterns to be able to project and/or alleviate congestion areas. He must understand meteorology, geology, chemistry, physics, & calculus, to be able to determine grades, inclines, drainage, structural stability, wind shear, friction, expansion, etc. so that rates of speed can be maintained around curves, bridges, and interchanges without having cars slide down, or have to drive too fast to keep on the curve, or have pylons that fall under the lateral stress. He must know the men and machines that lay the asphalt pour the concrete, and hang the steel - their capabilities and limitations in order to not design something that can't be built.

He uses existing materials and technologies for his designs. He may apply them in traditional ways or come up with new innovations in how to use particular material combinations together or how to apply techniques and technologies to different materials than they had been intended for. He must keep up to date on new techniques and new technologies and also know when to phase out the old ideas and machines. He may create designs that take upcoming innovations in materials or equipment into account. He must also know when the requirements call for something completely new and different. He doesn't build the new technology or come up with the new recipe for concrete. He looks for any technology that someone else has built or that may be coming available. Or he specs out what is needed and hands that off to scientists, chemical companies, vehicle manufacturers, and steel mills to develop the new slip-resistant, super strong, last forever, asphalt guaranteed to never crack between -50 and 150 degrees.

The Architect can direct the building of the interstate. He may be able to teach others how to use the technology he's applied to his designs, but that's only because he knows how it all works together. He probably knows enough about running the machines to be able to pour concrete or lay asphalt. Maybe he even can do some steel-work. But that's not his specialty. He may know enough about so many different things that he may be able to develop his own new technology such as a new composite concrete-plastic foam mix. But, he's probably not as good at that as a dedicated scientist. He may make his interchange aesthetically pleasing or at least not offensive. But, that's not his primary concern. It's functionality and efficiency that he's after. Can he design and/or build a school? A shopping center? An industrial park? Perhaps. In a pinch. But it's not his specialty and it may not be pretty...not many like asphalt-colored grocery stores. And kids don't color within the lines – so how are they going to walk down hallways and obey all the traffic patterns laid out so nicely in yellow paint on the floors?

The Architect's customers are entire population centers, municipalities, counties, states or countries.

Developer -

A SharePoint Developer is very much like any Software Developer. And Software Developers fill the role of the scientists, chemical companies, vehicle manufacturers and steel mills in this analogy. They may be proactive or reactive. Proactive scientists and companies would come up with the new formula of asphalt because it can be done. Or, because the need is being projected for all future projects. Or because they want something to sell. Reactive scientists and companies would be taking requirements from someone, like an architect, construction companies, or even another scientist and coming up with a the new asphalt that fills their need. Oh, they need to make sure the color is right. That it hardens in a certain amount of time. That it can either be used with current equipment or they specify, and maybe even design, new equipment. They're not so concerned about existing technology unless part of their requirements require some sort of integration. They are coming up with new technology. New building materials. New machinery.

The developer has plenty of knowledge about existing technology. But probably is a little light on techniques, real-world uses, and actually applying the technology to a problem. The developer may be able to explain the uses of his new tech. Or, he may have just built it and left it to the engineers to figure out how to apply it. If making it pretty was included in the requirements he will make it pretty - but otherwise is just coming up with new, amazing things for himself or others to use.

Can the developer run the machines? Pour concrete? Hang steel? Maybe, but I would guess probably not. He knows about it and may be able to watch it for hours, but that's not his thing. That's old. It already exists. It's boring. Now what about a truck that plows the earth, breaks up rocks, unrolls rebar, pours our new quick-drying concrete, smoothes it flat, then paints those irritating lines in 7 different colors - as long as they're yellow? Hm? Call it the RoadMaster 9000.

The Developer's customers are whoever asks for, or will purchase, this new and amazing stuff he just came up with.

Administrator -

SharePoint Administrators are like any other systems administrators in IT except instead of knowing only one or two systems, they have to be skilled with 4-5 and very familiar with dozens and how they all interact. To continue the analogy, SysAdmins are like the engineers, heavy constructors, and road crews that build and maintain the infrastructure. They are there to take the designs, the machines, and the materials and come up with a plan of action, implement that plan, and get the roads, bridges, interchanges, ramps, ditches, tunnels, etc. built. They are the ones that drive the trucks, pour the concrete, lay the asphalt, weld the steel, and paint the lines. They don't come up with new designs...they just build. They may come up with more efficient methods for working. They are probably the best source of information about deficiencies in current tech or materials. They will even have great and wonderful ideas on how to improve designs, or know exactly how a plan will fail unless modified.

They know how things really work in the real world. They have to build it. Then they have to fix it when it breaks. When the deep cold creates potholes, they have to fill them. When the scorching heat expands a bridge beyond its joints' ability to handle, they repair the cracks. When the surfaces need to be stripped off and reapplied because of normal wear-n-tear, they are the ones that bear the brunt of hazardous drivers, heat, rain, and cold to tear off only the upper layers without damaging the foundation. Then they apply a new veneer using that new asphalt that someone bought for them to use. But, at least they get to drive that new RoadMaster 9000. Boy it sure can lay some road. And it's air-conditioned.

The Administrator's customers are everyone that drives down that road.

Site Designer -

The SharePoint Site Designer is very much like any other web designer - just with different tools at their disposal and a need to understand a multi-layered hierarchy for creating final pages displayed in a web browser. They are also akin to urban planners and real estate developers. They're very, very interested in that new highway system. In fact, they may have even asked for it. They certainly will take advantage of it. They don't build the roads. They use them. They don't care about what machine lays what type of asphalt in what temperature how fast. They just care that there is a new roadway system that they can build around. They design and create the places people live and work. They design and create the "surface streets" that connect to the highway system, the shopping centers, the business & industrial parks (where the developers all work), the traffic lights, the turn lanes, the parking lots. But they also design and build the houses, the restaurants, schools, grocery stores, recreation centers, hospitals, parks, and bike trails. They beautify the neighborhoods. Landscape the roadways. Erect and paint the privacy fences. Use a particular shade of red for traffic lights.

They function very much like the Architect - but their efforts are scoped and scaled to a completely different customer. Their customers are individual communities, businesses, city councils, neighborhood associations, etc. They work with the people. They listen to what the people need. They may contract the company that has the architect to design a new interchange to lower traffic accidents. They certainly complain about the potholes and traffic delays. They are the ones the people go to when they a new place to shop, a new place to work, new sewer systems, a new place for the kids to play, or a new way to get to work. They are also the ones people go to improve and revitalize the old downtown areas and make them thrive once more.

Manager -

I won't presume to tell you managers how to do your job. That is not my place. However, to differentiate the Manager from the Architect -

In this case, the manager is the strategist, the government, the banker, project management, sales, marketing, and collections. They coordinate all the efforts. Determine the rules. Set the standards. Determine the budgets. Pay the bills. Sell the product and collect the money. They know the technology and can sell it or know when someone is blowing smoke in their general direction. They know how to get things done with how many people in how much time. They know how much that RoadMaster 9000 costs. They also know where to buy it cheap. They know how many of them to buy because they listened to the engineers and road crews (SysAdmin) complain about those ancient things they had that were almost 4 years old and didn't have air-conditioning. They know how to get the money, or how to say no. They sell the architect's designs and set the schedules for the road crews. They determine when it's ok to close which lanes during rush hour so the bridge can be resurfaced and take all the heat of the whining and complaining at the city council meetings. They set the shade of the traffic lights because they need to be standardized so we can get a good price.

They tell the Designer that they can't put a chemical plant next to an elementary school playground no matter how much that business pays in taxes...wait, how much was that again? Maybe we can move the school. They set the pay scales, draw up all the contracts, procure all the resources, enable the workers, fight the unions, and wave the flag. They make sure the Architect's designs can be built within budget and that they are not so new and progressive they can't be sold. They ensure that the Developer builds things that are actually useful and sellable, that the Administrator delivers that new road on time and under budget, and that the Designer plans the community with the people in mind. No matter how pretty that tree would be in the spring it can't be in the middle of a major intersection.

But mostly, they keep the team functioning as a team. They recognize the members as individuals. They encourage them to excel and guide them to becoming better people, better employees, and better members of the team. They keep the team on track – techies tend to find tangents, over-think, and "go that-away" unless kept on the straight and narrow. Techies also tend to be a bit literal, which comes from working with computers that don't care what you meant – they know what you did. This often can lead the technical expert to misinterpretation of requirements, ideas, or anything else that isn't spelled out in writing.

The manager's toughest job is figuring out how to make the team mesh together and share knowledge and ideas. Technical experts also tend toward being very confident in their abilities and protective of their knowledge. This usually comes from very few others knowing what the techie is talking about most of the time and having the ever-present danger of someone else taking a piece of code, a drawing, or a recipe, claiming it as their own and getting credit for something they didn't do, or worse, making money from it. Too often the poor manager will be just that culprit, not necessarily intentionally, but because they are the public face of the team to customers and executives, they tend to be associated with what the team produces. And the poorer manager will revel in that glory.

Their customers are basically everyone.

Final -

So, this is my take on SharePoint teams in the enterprise. It is just my opinion based on my experiences and the stories and anecdotes related to me over the years. I'm sure there as many different opinions as there are people that care about this topic.

So, share some good times and go build an effective team – no matter the form.

SharePoint Farm Migration – successful…

My Domain controller died last week and with it went my SharePoint Web Front End and Exchange server. So, I spent a long weekend installing new hardware and extracting the SharePoint data so that I could bring it over to a new farm in a new domain.

Unfortunately, my backups did not extract properly since I wasn't going to the same versions of the OS or SQL Server. Thought I'd take the opportunity to upgrade to Server 2008 and SQL 2008. Caused me more work.

Fortunately, I could still access the SQL server via cached credentials. And, since I had put Reporting Services in SP Integrated mode it had an installation of MOSS on it. I turned on all the services there and then through a series of nasty hacks got it to recognize itself as the only WFE in the farm. Then I could do a current backup.

Got everything installed into the new domain and created a new farm. Restored all my backups and they worked fine….after I discovered a few things.

In this process one must remember the following:

  • If moving Sites from one domain to another, make sure the new domain does not duplicate the user account names of the old domain. They will look like they resolve, but you will get errors because the SIDs are different.
    • Install everything with a totally new and differently named account. Then remove all the security from your sites and reconfigure it.
    • If you miss one or more accounts that are named the same in both domains, they will resolve in the new domain and look like they are working, but will not allow access.
    • If you have missed accounts, and are doing an stsadm.exe –o restore operation, you will get an error that "The File Exists". What this means, in this case, is that your CMD session is logged in with one of the duplicated account names and so you are getting a SID conflict. This is VERY poorly documented.
  • Be sure to learn exactly where everything is in Server 2008. It, like in Vista, screws around with things in the control panel and even IIS7 looks different.
  • While you must allow the IIS6 compatibility selections to be installed since you're using MOSS 2007, you won't actually be able to administer anything with that interface since you have MOSS.

And for my particular situation…

While Exchange and SharePoint can coexist on the same server just fine, one must install Exchange FIRST and then SharePoint. I didn't remember this and really don't want to go reinstall my farm now that I have it working. So, am using an external mail handler while I work on a separate Exchange server.

Now just have to figure out how to get OWA to work when Exchange isn't on the same server as your web server. This isn't a problem at work, but is a pain when I can't do NAT configurations based on domain names…silly SOHO routers don't do that. Maybe I'll have to invest in a business-class router. Been a long time since I've played with the Cisco IOS…even let my CCNA expire. Oh well. That's another blog.

Later.

SharePoint Conference 2009 and Trip to Las Vegas

Our trip began well enough and the only things that bothered me revolved around "sticker shock". The conference was fine, but not very enjoyable. Most everything covered, I already knew. Even a few of the speakers brought that up in conversations when I mentioned that I didn't learn much and they were surprised that I had expected to do so. Interesting…

The problem with the conference was that it was TOO frackin big. There were 7600+ attendees, 200+ Microsoft Employees, 120 speakers, and 160 sponsors/exhibitors who brought out their "A Teams" for the event. (This means "booth babes" were more than abundant.) This amount of people meant that everything was run like a poorly managed Army maneuver. Led to meals like cattle and the break-out sessions were filled with 2-400 people each so there was no room for anything but lectures.

This also meant that there was no real chance to do any real social networking since everyone was trying to get time with all the "rockstars" or make that "special" business connection. So, no real time with my close colleagues – even if one attended the unofficial social gatherings.

As for the officially sponsored social gatherings – that's where things started to go wrong for us.

By Tuesday, Trudy and I had toured Vegas, eaten at the Top of the World, gone from New York to Paris to Venice to Rome. We'd seen sharks, the Titanic, and Phantom of the Opera (The best 95 minutes of the week, btw). Tuesday evening was supposed to be a 80's themed beach party with Huey Lewis and the News. I had arranged with one of the event sponsors, KnowledgeLake, to get Trudy and my co-worker's new bride, Linda, into the party even though they were not conference attendees. They really want my business so they agreed to give them VIP passes. We were told these would get them into the party and also into a private cabana for a catered party. Sounded good to me.

However, the Mandalay Bay staff proved that all the hunches, misgivings, and little signs we had been noticing all week to this point were well founded. The staff did know about the VIP passes, but they weren't letting anyone with them into the party – unless they had also paid $150 for a "Guest Pass". I did phone my contact at KnowledgeLake and he offered to come escort us through – but that ended up taking so long that Trudy and I got tired of the dirty looks we were getting from the MB staff and left. Apparently we weren't the only ones treated like crap that night – as some of the people who HAD paid the extra money to get in were turned away due to the party being "at fire code capacity". Turns out that the party was sold out (which I knew) but they had not actually be checking to see who signed up or bought the tickets, they were just letting any conference attendee into the party – until they were getting in trouble for that fire code thing.

Unfortunately, this made us start really noticing just how much the Mandalay Bay sucked. I've stayed in better Motel 6's. I put our hotel experience in another post.

Back to the conference, I did win a Flip Cam and got lots of swag. I saw as many presentations as I could and was glad I could look at the videos as there were TOO many sessions to take them all.

As for our trip as a whole, we basically enjoyed the week and had a nice time. But this was mainly due to having someone to share the experience with and not the conference or the hotel. Next conference I won't be taking Trudy and she agrees that it was pretty boring for her during the day unless she wanted to spend mucho dinero.

I look forward to the next, hopefully smaller, SharePoint event. I'll probably talk your ear off then.

 

 

 

Mandalay Bay Las Vegas – Don’t Do It!

Recently attended the Microsoft SharePoint Conference 2009 held at the Mandalay Bay Hotel & Casino in Las Vegas, NV. Since the conference was there, we booked the Mandalay Bay as our hotel for the stay. This was a mistake I will not repeat as the experience was not something I will soon forget.

Our room cost us $149/night for 7 nights stay. Here in KC, or any place I've stayed over the past 2-3 years (that would be many different places in the country, btw), that would get you a deluxe suite with lots of amenities including breakfast, coffee, wi-fi, clean linens daily, gym, pool, and staff that at least made you feel like you matter – at least until you pay your bill.

At the Mandalay Bay this got a small-ish room with a bed, shower, bath, TV and a toilet. Yes, it all looked nice, but wait…

  • Breakfast meant going to one of the many restaurants in/around the casino. This ran an average of $18/person.
  • Coffee was gotten either the same place as breakfast or at one of the Starbucks in the casino. Regular coffee ran $5-7.00 at either place, but Starbucks was 'per cup' while the restaurants usually would get you a refill if you waited long enough and asked for it often enough.
  • Wi-fi – they had it. But it was $14.99/24 hours/ laptop. Yes, Trudy and I both had laptops. We were told that conference attendees were to receive a discounted rate of $5.99/24 hours/laptop and this would be adjusted at checkout. Well, they front desk knew of the discount but refused it to us because we didn't book our hotel room using the higher "conference rate".
  • Clean linens – yes, we got them – once every 3 days. Unless you asked nicely of the maids, which we did, and then we did get them more often. Of course that didn't mean they were comfortable. I've had thicker, softer towels used as grease rags for auto repair work. At least they could use fine-grit sandpaper to scrape your skin after a shower instead of these towels.
  • Gym – we had fully planned to continue our daily workouts since there was a gym on premises. That plan changed when we found out that gym access was $30/person/day. This did include basic spa access, but no "special services".
  • Pool – yes, there is a fine looking pool area – includes a wave pool, lazy river, beach, and plenty of sun. However, one must wear shoes on the sand – not for the heat, but so you don't walk on all the cigarette and cigar butts in the sand. Don't even think about having any space around your lounge chair – they are practically butted up against each other and leave no room for any sort of normal "beach fun". The Lazy river requires an inflatable ring which will run you $23 to rent it for a day – don't lose it or have $95 added to your bill. It's just a kid's inflatable ring.
  • The Staff – well, let's just say prison guards would make you feel more welcome and be more apt to do things for you than the people working at the Mandalay Bay. Everyone expected extra money for doing their job and giving basic customer service. I am perfectly willing to tip, but tend to want GOOD service, not just mediocre to crappy. Most were quite aloof and blatantly uncaring. We were just another source of green bills.
  • Let's talk about other things –
  • Meals were super expensive. The best deal we got was at the House of Blues. At least they included hash browns and toast with breakfasts. And didn't charge for refills on soda. But, they did lose our room charge card, which caused a painful experience with the front desk. Average meal cost was $25-45 per person. The low end included when we just got coffee and muffins for breakfast. The high end was when we ate "cheap" for dinner one night.
  • There were snacks in the room when we arrived. Chips, chocolate, nuts. In any other hotel where we paid so much, these would be complementary. Not at the Mandalay Bay. I had read a review that warned us that these were not complimentary. I learned that the little single-serving Pringles cans would have cost us $5 if we had even moved them from their tray. And the mini bar where the cokes and water were stored (yes there was alcohol as well) would have run us $6/coke and $5/water. You don't even want to know the cost of the alcohol. We saw a price for a bottle of Bacardi that told us we would never drink there - $325/bottle – for regular Bacardi rum and only a 750ml bottle.
  • We could have bought many tickets to the things we wanted to see and do at the Mandalay Bay concierge desk. But, that experience wasn't like other concierge's I've dealt with before. Places in KC, New York, New Orleans, etc. have concierges that have connections, get you deals, advise you how to best spend your time/money, and hope for a generous gratuity in return for treating you like you are "somebody". The concierges we dealt with at Mandalay Bay not only didn't seem to care about service, but actually charged more to acquire tickets/services for you through the hotel than it would run to do it yourself. And if you managed to pick up the coupon books stacked around other hotels, then you'd save even more.

 

Overall, when we stayed at the hotel, our Las Vegas experience was unsatisfactory. When we left the hotel, we had a pretty good time.

Now, add to this the fact that I contracted the H1N1 influenza strain while at the conference and you can imagine that our memories of this experience lean toward not wanting to return – at least not to the Mandalay Bay.

If we had been prepared for the lack of amenities at the hotel, which to me mean things included in the price of the hotel room, and the hotel staff had treated us as I have come to expect from other hotels around the country, then I think we would have had pleasant memories and might even recommend this hotel to others.

Limiting the SharePoint People & Group column to certain AD users or groups

A common scenario: A client wants to filter the "People Picker" in a SharePoint list to limit which AD Users or Groups are available to choose from. For instance, when selecting what AD User/AD Group can be added to an Alert on a SharePoint List.

A very common answer is to dive deep into code and spend hours and days figuring out the exact LDAP query and how to make it run and get everything to work in SharePoint. BAH! Too much work.

 

This one can be done out of the box.

First, why the LDAP thingie doesn't easily working:

The default behavior of the People Picker is not to query AD via LDAP. It is to query the SharePoint User Profile database. This is populated via user import. In MOSS, it is through a scheduled (or manual) user import. In WSS, it is done when any AD account or group is added to any site via explicit permissions or when added to a SharePoint group in a site.

The Name property will be the AD account name and so it looks very much like it is pulling from AD.

You can code another solution, but getting the right information into a usable SharePoint format can be tricky. But for this, you don't have to.

So, how to address the issue:

As I said, this can be with OOTB functionality if you're willing to do a few minutes work ahead of time.

1. Make a list (not SP list..just a list) of the AD users or groups you want for this particular people picker to choose from. (I usually limit to either users or groups and don't mix them in the same SP Group for this purpose.)

2. Create a new SharePoint group in the site where this people picker exists.

3. Do not give the SP group any permissions. It is just a holder.

4. Add the AD groups from your list in Step 1 to this SP group. Remove any individual account (such as yours) from the group.

5. In your people picker column settings, change the "Allow selection from" to "People and groups".

6. Then change the "Choose From" to "SharePoint Group" and in the drop-down choose the list you created.

 

How to use this nifty little thingie?

When you create a new list item, you will see the people field with a "Check Names" and a "Browse".

Since you limited the people picker to only what is in the SP group, anything typed in will only be checked against the groups in your SP group. So, it is likely that this will be unsatisfying.

However - look at that "Browse" button. Click it! Notice that it brings up the list of the AD groups you put into your SP Group.

I think you get the point.

 

Have fun!

Reporting Services-SharePoint Integrated Mode Add-In Fix

We had a request to update a URL in Central Admin so Report Builder 2.0 could be utilized when using RS in SharePoint Integrated Mode.  There was more to this than met the eye.

The developer provided an MSDN link to an article that showed how to update a link in Central Admin.  It didn't look like this would be enough to accomplish the goal so we researched a bit more and learned that we needed SQL 2008 SP1 applied.  After doing that and updating the URL, it still wouldn't work (got page not found error when trying to edit a report using Report Builder from SharePoint), so we dug a bit more.

Found out that there is an update to the RS Add-in that needs to be run on the WFE. 

However, there is a bug in the 64 bit RS Add-in update. The following workaround seems to solve the problem for us.

You can get RB2ClickOnce working if you copy the contents of
<SQLSEVERINSTALLDIR>\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder TO C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI\ReportBuilder.

Note:  For above command, if you have a single server install the source and destination paths are on the same machine but if not, you copy from the DB server path to the WFE server path
Make sure you have a backup of the original <ISAPI>\ReportBuilder directory.
After you have copied the files you have to update the "Custom Report Builder launch URL" to
"/_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application".

So, in summary to get the Report Builder 2.0 functionality inside SharePoint for RS reports using SharePoint Integrated Mode do the following:

  1. Insure the original RS Add-in has been installed (not the "clickonce" exe that won't work)
  2. Insure SQL Server 2008 SP1 is installed
  3. Do the step to copy the folder as described above
  4. Update the Custom Report Builder launch URL (if not already done).  This is found from Central Admin under Application Management > Reporting Services > Set Server Defaults.
  5. Verify all is well by going to a report library in SharePoint and "Edit in Report Builder" from the item menu.  It should now open the RB 2.0 app.
CEWP Menu Hidden by Windows Media Player

 

The issue we were running into was that when using a Content Editor Web Part to render code to play video in Windows Media Player, the video played just fine. However, the drop-down menu for the CEWP was now hidden behind the Windows Media Player video.

Here is the code we were using (generic URLs):

<object classid="CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95" width="600" height="400" id="mediaplayer1" title="Win Media Player">

<param name="FileName" value="http://web.domain.com/site/SiteImages/video.wmv">

<param name="AutoStart" value="True">

<param name="ShowControls" value="True">

<param name="ShowStatusBar" value="False">

<param name="ShowDisplay" value="False">

<param name="AutoRewind" value="True">

<param name="DisplayBackColor" value="False" />

<param name="BufferingTime" value="6">

<embed src="http://web.domain.com/site/SiteImages/video.wmv " width="600" height="400" autostart="True" wmode="transparent" type="application/x-mplayer2"

pluginspage="http://www.microsoft.com/Windows/Downloads/Contents/MediaPlayer/" filename="http://web.domain.com/site/SiteImages/video.wmv" showcontrols="True" showstatusbar="False" showdisplay="False" autorewind="True" displaybackcolor="True" bufferingtime="6"></embed>

</object>

 

All this is pretty standard.

I had encountered this with Flash video and so tried just adding

    <param name="wmode" value="transparent"/>

This works fine when we encounter this with Flash video. But, not here.

Found out that Windows Media Player is not really rendered as part of the page by the browser, but actually is called by the code to be rendered by the OS. It is placed on the page according to the code, but is not "part" of the page.

This is not normally bad, as it allows the OS to use a different process, outside the browser, to do playback and is a more efficient way to manage system resources. But, this means any content on the page is rendered "beneath" the media player window. So, it's not even a layer we could manipulate with <DIV> layering.

The solution is to force the browser process to render the Windows Media Player and not just call the OS process. This is done by adding a parameter to the code as follows:

    <param name="windowlessVideo" value="True"/>

This parameter is False by default so setting it to True keeps the browser from calling the OS to create a window layer.

A load off my mind and I won't lose as much hair now.

Have fun!

SharePoint Meeting 9/8/09 at 7 PM JCCC Regnier

Karen Sorensen of Johnson County Wastewater will be presenting on the subject of best practices for file management under Sharepoint.

FILES IN SHAREPOINT- UPFRONT DESIGN FOR SUCCESS:

Has anyone had problems with the way the files had been named.

Have you had conflicts with other systems such in Outlook or sharing files with folks outside their network? How SP files are or would be shared and archived.

For example, any plans for an extranet. There are legal issues involved.

In some cases you might consider what to do in case of a law suit.

 

Karen Lynne Sorensen is currently the Internet Projects Coordinator at Johnson County Wastewater. She has worked for private industry ranging from Boeing and Northrop to hospitals and environmental cleanup companies. In addition, she has worked for major colleges in the KC metro area helping faculty to integrate technology into their curriculum.

The Journey Continues

Things are happening. This last week, I thought I really blew it in my eating habits and exercise program. There were some particularly stressful days at work and I found myself dropping back into the old habit of eating food when stressed or depressed. I ate out for lunch Monday and Tuesday. And while I didn't intend to do so Wednesday, a co-worker invited me out for lunch so we could chat about the things going on at work. So…

Then due to an after-work appointment with the chiropractor and then needing to be at the lodge early, I didn't get my regular workout Thursday. Then Saturday I was gaming with friends all day and again skipped a workout. And Saturday I had Arby's for lunch and then the most wonderful ribs for dinner. And later a chocolate brownie fresh out of the oven.

The only thing I can look back on and smile a bit about the week is that even when I was eating for the wrong reasons I wasn't even able to eat very much. Apparently, I'm getting used to the smaller portions. Oh, I would have liked to eat more ribs or brownies. Just couldn't think of doing it. Was TOO frackin' full!

Then…the dreaded weigh-in this morning. Don't know how it happened. But, the scale said "269". So I got off and back on. It must be defective because it still said "269". I moved it on the floor in case it wasn't flat and it still said "269". I figured it was stuck, so put my PJs on and weighed again – it said "270". Ok….not stuck.

I don't know why, but apparently I've hit the 30 lbs. weight loss milestone. WOO HOO!

So…I had set a goal to lose weight. I had set my first milestone goals based on some traveling I had planned. This coming weekend (9/12) I had been going to speak at SharePoint Saturday New York and wanted to be thinner so I'd have a chance of fitting in the airplane seats, but mostly so that if there were any pictures, they wouldn't look as bad as the last SharePoint Saturday I attended.

The other milestone I set was to have lost more weight by when we left to go to the SharePoint Conference 2009 on October 16th. Again, to better fit in airplane seats and look better in pictures, but also so that I could walk around Las Vegas and not be totally winded after only a block or two of walking. And perhaps even participate in some fun things without feeling totally self-conscious.

My goal for 9/12 was to have lost 30 lbs. That would have been an average of 5 lbs. per week since I began this ride. My goal for 10/16 was to have lost 50 lbs. I thought the weight loss might slow a bit, so set a more reasonable goal.

My wife is jealous. She's lost a few pounds, but not like me. I keep encouraging her and she keeps at it. She says she feels better for the exercise and the eating better. She says she sleeps better at night and has more energy during the day. So, I think she'll keep at it. I hope so, I want her to feel as good as I.

I've had to toss my favorite jeans. They were feeling very loose and I ended up taking them off without unfastening them. Didn't have to even push them over the hips. So…they just came out of their last laundry (still fastened) before I send them off to Goodwill. I did have a couple of older (read smaller) jeans so I pulled them out. There were sizes 40, 44, and 46. I had been in a 48 and considering a 50 early in July.

The 40s…uh…no. Not yet, anyway. I put them where I could see them fairly regularly. I didn't even know I had anything that small in my closets. The 44 (I didn't know it was a 44 when I put them on) was tight, but I could suck it in and fasten them. They were tight enough I couldn't put my normal utility belt stuff in them. So, I was thinking that maybe I hadn't lost what I thought. Then I tried the 46. They fit well, if a bit loose, and gave me just enough to put wallet, keys, etc. in the pockets. So…down a full size in jeans! And coming up on the next one down.

My work-shirts are baggy but the next size down is still a bit tight around my still quite large belly. Maybe another 10 lbs. or so and I can toss the 3X totally.

So, I've met my first real milestone goal. I've lost 30 lbs. I can hardly believe it! Now I have another one to meet. And I need to set another short-term goal. I'll need to think about it. My long-term goal is 175 lbs. I can't believe I'm less than 100 lbs. away from that. It's still a long way…but doesn't seem so far now.

I almost want to take a picture…my friends Saturday said they could see a difference in my face. I'm afraid to really look at two pics side-by-side. Maybe later.

1 - 10 Next

 Kevin's Calendar

2/9/2010 11:30 AM   Mid America SharePoint User Group 
2/10/2010 12:00 AM   SPTechCon - SharePoint Technology Conference 
The future of SharePoint education is at SPTechCon 2010 San Francisco!
Planning a quick migration to Microsoft SharePoint Server 2010? Attend the SharePoint Technology Conference in San Francisco, where...
2/9/2010 7:00 PM   SharePoint - Kansas City Users Group 
2/27/2010 12:00 AM   SharePoint Saturday 
3/4/2010 5:45 PM   KCOG Meeting 
3/9/2010 11:30 AM   Mid America SharePoint User Group 
3/9/2010 7:00 PM   SharePoint - Kansas City Users Group 
4/1/2010 5:45 PM   KCOG Meeting 
4/13/2010 11:30 AM   Mid America SharePoint User Group 
4/13/2010 7:00 PM   SharePoint - Kansas City Users Group 
(More Events...)

 Contact Kevin

 ‭(Hidden)‬ Admin Links