'Shopping Cart' Solution to deploy applications in SMS 2003 (Full Version)

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003



Message

amalekani -> 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 1:01:38 AM)

Hi folks [:)]

We are using SMS 2003 SP2 in our environment. We are looking for a software deployment solution to offer 'self-service' to the users, so that they can choose for the appliations to be installed on their machines. [>:] It would be a kind of automated approval for a selected range of applications.

Anyone, who has got an idea as how we can have this solution applied please reply. 



ldekalb -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 2:45:26 AM)

Check out Ron Crumbaker's SMS remote Tools web tools. There's a function in that to populate a drop down box with applications and then a button to add, via direct membership, a client to a collection for install.

You'd need to play around with the access to the collections for all users.

The other way is to have a VBscript that does a similar thing but populates and AD group, enable AD group discovery, make the group a criteria for the collection etc etc. Again you'd need to play with the perms for add / delete to the AD group.

That should get you headed in the right direction.




amalekani -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 3:09:21 AM)

Thanks 4 replying.. could you please let me know where from i can get Ron Crumbaker's SMS remote Tools web tools. Is it a freeware which i can modify as well or a licensed product? If possible please post a link to it.



bwilms -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 7:52:50 AM)

SCCMExpert Self Service and 1E Shopping are two commercial products available that do what you request.



michael.zimmer -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 9:17:04 AM)

We use http://www.sccmexpert.com/Products/ESD.aspx and love it.  They are a great company to work with and always willing to help out.



rzander -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 11:22:14 AM)

If you want to create your own solution: http://sourceforge.net/projects/smsswreq/ is an example of a simple mail based workflow (Source-Code in C#)... 



bmason505 -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 3:21:50 PM)

Hey, let me hijack this thread to give you big kudos for the SMS Client Center, Roger!  I love it.



skissinger -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/3/2008 5:57:22 PM)

Ron Crumbaker's 3.21-->  http://www.myitforum.com/articles/19/view.asp?id=8662
Some customizations to Ron's excellent console.

PS:  adding to Brian's kudos... Roger's Client Center is awesome!



amalekani -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/4/2008 8:01:03 AM)

Thanks all for the wonderful help!!



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/4/2008 10:11:02 AM)

I'm interested in the  http://sourceforge.net/projects/smsswreq/  solution, does anyone have the English Documentation, I was able to follow the German docs to certain point but I need Clarification on configuring the WEB.CONFIG file. any help is appreciated.



rzander -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/4/2008 3:13:49 PM)

I've found an english draft of the documentation :-) It should be available in the download section on http://sourceforge.net/projects/smsswreq/ ...



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/4/2008 3:53:27 PM)

thx Roger for the link.
I'll apply it and let you know.
Have you set it up yourself? if so, will it be okay to ask you for assistance if needed?



skissinger -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/4/2008 5:31:17 PM)

<note, heavy sarcasm ahead!> I suspect Roger has set it up himself.  Once or twice. </sarcasm off>

Roger has graciously shared a lot of wonderful tools--> http://www.myitforum.com/articles/8/view.asp?id=11268

If possible, could you keep the conversation going here?  We'd all love to learn more about his stuff.



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/4/2008 6:04:38 PM)

Loved your Sarcasm (I almost used Fs, Ss and Ps in my response but since it is you Sherry...) and Roger I'm sorry about not connecting the dots (too busy LOL).

Roger, in the setup I assigned port 83 to the site, and from the Docs it seems I should not need a Host Header ..Correct?

My question is (and looking at the web.config changes below):

         1- I can't connect to the Site URL and corresponding Approval page, is my link correct below? or should it be srvsms-2003.smsswreq:83.scvwd.gov?

The WebConfig is:

 <appSettings>
<add key="eMail_Sender" value="helpdesk@valleywater.org" />
<add key="SMSServer" value="srvsms-2003" />
<add key="ADPATH" value="LDAP://scvwd.gov" />
<add key="ApprovalURL" value="http://smsswreq:83.scvwd.gov" />
 </appSettings>
<connectionStrings>
 <add name="SMS_ConnectionString" connectionString="Data Source=SRVSMS-2003;Initial Catalog=SMS_ADM;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
 
thank you.



skissinger -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/4/2008 6:21:14 PM)

I've never setup this tool; but just as something to try.... try value=http://smsswreq.srvsms-2003:83  or value=http://smsswreq.srvsms-2003.valleywater.org:83
just a guess, though.



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/5/2008 3:05:43 PM)

Thx Sherry for the tip, and I've used many of the combinations but no Go.

I'll give it some more wirl next week, and i hhope to hear from Robert... Have a nice weekend all.



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/5/2008 3:07:45 PM)

Sorry i meant Roger... [image]http://www.myitforum.com/forums/micons/m16.gif[/image]



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/11/2008 11:47:34 AM)

 

Hi Roger, as you see in the uploaded and enmbeded PIC i was able to get so far, ( I hope the PIC uploaded okay). also i had to make the SUBMIT button visible in the default.aspx file because it was set to false. As you see in the catalog list I have no listings so how do i go about it?

Thank you for your assistance on this.

[image]local://upfiles/18133/E9AC7B9428214B05A296672DE3492F4D.jpg[/image]



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/11/2008 11:53:30 AM)

Also if it helps here's my web.config file:


<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings>
<add key="eMail_Sender" value="gkamenjati@valleywater.org" />
<add key="SMSServer" value="srvsms-2003" />
<add key="ADPATH" value="LDAP://scvwd.gov" />
<add key="ApprovalURL" value="http://srvsms-2003:8070" />
</appSettings>
<connectionStrings>
 <add name="SMS_ConnectionString" connectionString="Data Source=srvsms-2003;Initial Catalog=SMS_ADM;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
   <compilation debug="true">
  <assemblies>
   <add assembly="System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
   <add assembly="System.Management, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation>
   <authentication mode="Windows"/>
  </system.web>
<system.net>
<mailSettings>
  <smtp from="">
   <network host="SRVEXCH3" password="" userName="" />
  </smtp>
</mailSettings>
</system.net>
</configuration>



rzander -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/11/2008 3:02:21 PM)

The Page tries to resolve the e-mail address of the loggedon user (SCVWD\GeorKame) from ActiveDirectory (LDAP://scvwd.gov). Check if the User has an SMTP e-mail address specified (AD or Exchange attribute). If the Application Pool runs with Local System priviledges, the computer account of the Web-Server needs to have the permissions to query AD UserObjects...

The Local System account must also have permissions to query the SQL database "SMS_ADM" on the SQL Server "srvsms-2003" to get a list of collections where the comment field starts with: "REQ:" followed by the mail address of the approver... Check if you have at least one collection with a valid comment field... and check if you have rights to query (read) the Table "Collection" on the SQL Server... Further, the account requieres the permission in SMS to add direct membership rules to SMS collections...

The Submit button will becomes automatically visible as soon as you have selected an application, you do not have to make it visible manually in default.aspx...



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/11/2008 5:14:12 PM)

thx Roger,  I just requested from our Net Admin to permit the srvsms-2003 account to query AD objects.
As you see from the embeded images i do (all users too) have SMTP email addresses specified in the Exchange attributes. Yes the application pool is running under the local system priviledges. and the local system account have the proper rights to collections, I just added the "REQ:gkamenjati@valleywater.org" to the coments fields of the collections. I do have all the admin rights to the SMS server and its database.
I hid the button and let's see how it goes.
here are the PICs and permission matrix



[image]local://upfiles/18133/4F2F3F44957B4144BB85D44F1E9B9E9F.jpg[/image]



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/11/2008 5:15:10 PM)

One more

[image]local://upfiles/18133/6DA58A0C2DAA4114AB0BF3BC6EC4DAA0.jpg[/image]



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/11/2008 5:43:54 PM)

You are the man roger, we are almost there...
here what i have so far.


[image]local://upfiles/18133/DC0D7E7AF42848118BB01E2B373742E7.jpg[/image]



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/12/2008 4:16:53 PM)

Roger I'm still not getting the requester e-Mail to show up despite that the SRVSMS-2003 computer account has READ permissions to AD, any thoughts of what is missing?

Thx.


[image]local://upfiles/18133/AD0ABA8E47784DCAB884337FF519819F.jpg[/image]



rzander -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/13/2008 7:43:29 AM)

It seems that the Function GetUserMail is unable to get a valid mail address (http://smsswreq.svn.sourceforge.net/viewvc/smsswreq/WebSite3/Default.aspx.cs?view=markup ; Line 37)
Any restrictions that my prevent an LDAP lookup in your environment ? Otherwise I would recommend to download the SourceCode and start it from VisualStudio to see why and where it fails...

Roger



rzander -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/13/2008 8:45:01 AM)

Can you also please verify if the LDAP Path (LDAP://scvwd.gov) does point to an AD DomainController... Otherwise you have to specify a server: LDAP://<DC Servername>.scvwd.gov

Roger



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/13/2008 10:11:23 AM)

First thing, thank you Roger for your prompt help, and yes the PATH does point to a DC called SRVDC, and for the purpose of testing I changed the LDAP statement in web.config file, but no success.
I think the proplem is that (and I'll confirm it with our Net Admins) our Exchange Server is not passing the addresses through AD. (Not Sure if i'm making sence here) I'll keep you posted.

Thx again.



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/24/2008 3:19:54 PM)

Roger, having the Local System account access the AD objects for read and listing is not working for reason or another.

What will it take to run the App pool under my account? and do i need to add an Impersonating account code into the WEB.CONF, if so, how?

btw, i did change it to my name but no success.

I hate to get to this point and give up on this, your assistance is appreciated.

[image]local://upfiles/18133/A3207D7ED4A9400B81680A883CBBD770.jpg[/image]



rzander -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/24/2008 4:45:25 PM)

You can change Line40 of Default.aspx.cs (http://smsswreq.svn.sourceforge.net/viewvc/smsswreq/WebSite3/Default.aspx.cs?view=markup)  to:
    DirectoryEntry entry = new DirectoryEntry(ConfigurationManager.AppSettings["ADPATH"],@"SCVWD\Myname","password");
to not use the application pool identity for the AD lookup...

or if you want to change the identity of the application pool:
http://gabe19.blogspot.com/2006/11/enable-domain-account-as-app-pool.html




gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/25/2008 1:02:21 PM)

As you see from the PIC, I have no errors, no warnings and only 35 messages from web.config file resulting from runing the source code, but still not getting the the "getmail" function to find anything.

I was wondering if I need the proper connection string added to the web.config..somthing like this:

<connectionStrings>
    <add connectionString="ldap://scvwd.gov/cn=georkame,ou=my_orgunit,o=my_org" name="myConnectionString"/>
   </connectionStrings>


[image]local://upfiles/18133/FBA0001DC8E84C40B24F71D76D8B9371.jpg[/image]



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/25/2008 3:44:44 PM)

Also if it helps, on the Debug side the getmail section returns "null" for results, but it is able to get the LDAP/user SID but somehow it can't find the proxuaddress SMTP.

FYI, our AD is Win2K. I have the proper rights to read, list and more to it.
the only thing is our users are not in an OU, they are in a container folder.

[image]local://upfiles/18133/E499CE41186E457B860F7D0523000BD4.jpg[/image]



rzander -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/25/2008 5:01:23 PM)

The connection string is used to connect the SMS SQL Database. As long as "result" is "null", no UserObject with the specified SID is found in AD. You may have to change the Property "ADPath" which is relevant for the AD connection to the value "ldap://scvwd.gov/cn=georkame,ou=my_orgunit,ou=my_org" ...?!



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/25/2008 6:12:16 PM)

It is still a No Go... There got to be something that is not being accessed. for now I'm going to blame it on our A.D. setup (LOL)

Oh well...

I just want to thank you Roger for your patience and great help, and especially for your generous time.
In the past couple of weeks I learned quite a deal about C# (..[:D] ..LOL).



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (6/26/2008 10:06:24 AM)

I'm back to (I guess I can't sleep)..LOL

Roger do you think the reason that a SID can't be matched in AD is due to SPN (Service Principle Name) account not registered?



gkamenjati -> RE: 'Shopping Cart' Solution to deploy applications in SMS 2003 (9/5/2008 10:36:41 AM)

Roger I just want to say, that your Software Request application is working perfectly for us.
The issue was glitch in our A.D. and when the consultant upgraded it to 2003 the whole thing worked like a Charm.

I didn't want to forget to thank you for a great tool.

As you recall from above posting, we could not get the app to red the SMTP email of the requester.

here's the PIC


[image]local://upfiles/18133/4ACE83D413D94FFCBC950A49BCE26491.gif[/image]



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.234375