myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


'Shopping Cart' Solution to deploy applications in SMS 2003

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> 'Shopping Cart' Solution to deploy applications in SMS 2003 Page: [1]
Login
Message << Older Topic   Newer Topic >>
'Shopping Cart' Solution to deploy applications in SMS ... - 6/3/2008 1:01:38 AM   
amalekani

 

Posts: 7
Score: 0
Joined: 9/3/2007
Status: offline 		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. 
Post #: 1
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/3/2008 2:45:26 AM   
ldekalb

 

Posts: 100
Score: 2
Joined: 5/12/2005
Status: offline 		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.



_____________________________

____________________________________
Death is just an engineering problem

(in reply to amalekani)
Post #: 2
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/3/2008 3:09:21 AM   
amalekani

 

Posts: 7
Score: 0
Joined: 9/3/2007
Status: offline 		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.

(in reply to ldekalb)
Post #: 3
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/3/2008 7:52:50 AM   
bwilms


Posts: 157
Score: 3
Joined: 3/8/2006
Status: offline 		SCCMExpert Self Service and 1E Shopping are two commercial products available that do what you request.

(in reply to amalekani)
Post #: 4
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/3/2008 9:17:04 AM   
michael.zimmer

 

Posts: 22
Score: 0
Joined: 4/20/2007
Status: offline 		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.

(in reply to bwilms)
Post #: 5
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/3/2008 11:22:14 AM   
rzander

 

Posts: 44
Score: 11
Joined: 4/2/2002
From: Switzerland
Status: offline 		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#)... 

(in reply to amalekani)
Post #: 6
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/3/2008 3:21:50 PM   
bmason505

 

Posts: 1965
Score: 100
Joined: 1/23/2003
From: Minneapolis, MN
Status: offline 		Hey, let me hijack this thread to give you big kudos for the SMS Client Center, Roger!  I love it.

_____________________________

Brian Mason
MCSA\MCSE\MS MVP - SCCM
Wells Fargo
http://www.miscusergroup.org/

(in reply to rzander)
Post #: 7
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/3/2008 5:57:22 PM   
skissinger


Posts: 1958
Score: 129
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		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!

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
Microsoft MVP - ConfigMgr

(in reply to bmason505)
Post #: 8
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/4/2008 8:01:03 AM   
amalekani

 

Posts: 7
Score: 0
Joined: 9/3/2007
Status: offline 		Thanks all for the wonderful help!!

(in reply to skissinger)
Post #: 9
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/4/2008 10:11:02 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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.

(in reply to amalekani)
Post #: 10
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/4/2008 3:13:49 PM   
rzander

 

Posts: 44
Score: 11
Joined: 4/2/2002
From: Switzerland
Status: offline 		I've found an english draft of the documentation :-) It should be available in the download section on http://sourceforge.net/projects/smsswreq/ ...

(in reply to gkamenjati)
Post #: 11
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/4/2008 3:53:27 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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?

(in reply to rzander)
Post #: 12
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/4/2008 5:31:17 PM   
skissinger


Posts: 1958
Score: 129
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		<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.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
Microsoft MVP - ConfigMgr

(in reply to gkamenjati)
Post #: 13
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/4/2008 6:04:38 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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.

(in reply to skissinger)
Post #: 14
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/4/2008 6:21:14 PM   
skissinger


Posts: 1958
Score: 129
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		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.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
Microsoft MVP - ConfigMgr

(in reply to gkamenjati)
Post #: 15
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/5/2008 3:05:43 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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.

(in reply to skissinger)
Post #: 16
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/5/2008 3:07:45 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		Sorry i meant Roger...

(in reply to gkamenjati)
Post #: 17
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/11/2008 11:47:34 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		 

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.


Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 18
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/11/2008 11:53:30 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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>

(in reply to gkamenjati)
Post #: 19
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/11/2008 3:02:21 PM   
rzander

 

Posts: 44
Score: 11
Joined: 4/2/2002
From: Switzerland
Status: offline 		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...

(in reply to gkamenjati)
Post #: 20
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/11/2008 5:14:12 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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




Thumbnail Image


Attachment (1)

(in reply to rzander)
Post #: 21
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/11/2008 5:15:10 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		One more


Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 22
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/11/2008 5:43:54 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		You are the man roger, we are almost there...
here what i have so far.



Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 23
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/12/2008 4:16:53 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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.



Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 24
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/13/2008 7:43:29 AM   
rzander

 

Posts: 44
Score: 11
Joined: 4/2/2002
From: Switzerland
Status: offline 		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

(in reply to gkamenjati)
Post #: 25
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/13/2008 8:45:01 AM   
rzander

 

Posts: 44
Score: 11
Joined: 4/2/2002
From: Switzerland
Status: offline 		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

(in reply to rzander)
Post #: 26
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/13/2008 10:11:23 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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.

(in reply to rzander)
Post #: 27
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/24/2008 3:19:54 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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.


Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 28
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/24/2008 4:45:25 PM   
rzander

 

Posts: 44
Score: 11
Joined: 4/2/2002
From: Switzerland
Status: offline 		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


(in reply to gkamenjati)
Post #: 29
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/25/2008 1:02:21 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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>



Thumbnail Image


Attachment (1)

(in reply to rzander)
Post #: 30
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/25/2008 3:44:44 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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.


Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 31
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/25/2008 5:01:23 PM   
rzander

 

Posts: 44
Score: 11
Joined: 4/2/2002
From: Switzerland
Status: offline 		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" ...?!

(in reply to gkamenjati)
Post #: 32
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/25/2008 6:12:16 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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# (.. ..LOL).

(in reply to rzander)
Post #: 33
RE: 'Shopping Cart' Solution to deploy applications in ... - 6/26/2008 10:06:24 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline 		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?

(in reply to gkamenjati)
Post #: 34
RE: 'Shopping Cart' Solution to deploy applications in ... - 9/5/2008 10:36:41 AM   
gkamenjati